Displaying a wide column with psql

People,

In case this list is still going . .

I have a table with a field that has up to 1,000 chars in it, when I
look at it with psql it only displays about 200 chars with a "…"
on the end of the string.  Even when I look at just one record and use
the \x option I get the same result - I googled for ages but short of
using pg_dump, I couldn't see an interactive way of seeing the whole
field.  Is it possible?

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW 2001
Australia
E-mail:  [hidden email]


--
Sent via sydpug mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/sydpug

philip_rhoades wrote

People,

In case this list is still going . .

I have a table with a field that has up to 1,000 chars in it, when I
look at it with psql it only displays about 200 chars with a "…"
on the end of the string.  Even when I look at just one record and use
the \x option I get the same result - I googled for ages but short of
using pg_dump, I couldn't see an interactive way of seeing the whole
field.  Is it possible?

You may wish to consider submitting your question to -general and providing additional, specific, detail on the data and execution environment.

You can use \copy to bypass display and send the data directly to a file.  At least that way you can see what it is the server thinks it has stored.

David J,