Search code examples
postgresqlpgadmin

Select whole column content in pgAdmin

I use PosgreSQL as database and PgAdmin as tool to manage it. When I write simple select (col is type of text and value of it is quite long, about 4k chars)

SELECT col FROM tab

I get this (there is about 250 chars before brackets):

abababababa(...)

but I inserted longer value. PgAdmin trim showed value and ends it with(...) string. How can I get whole content inside PgAdmin?

Solution

  • Try set this value in PgAdmin config:

    File > Options > Query Tool > Max. characters per column

    Look on settings on this page

    EDIT: For full column content you have to use -1, if left empty PgAdmin3 automatically replaces it with a 0 and nothing is shown but "...".