On 09/01/2014 08:05 PM, Philip Rhoades wrote:
People,
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?
Have you tried \pset format wrapped?
http://www.postgresql.org/docs/9.3/interactive/app-psql.html
\pset
Thanks,
Phil.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
