Adrian Klaver-4 wrote > 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. Philip: Can you get it to reproduce without the table? I did: SELECT repeat('x',10000); with various incantation of \x (on/off) \pset format wrapped/unaligned And could not get it to reproduce with 9.3 psql on 9.0 server I presume what you are seeing is effectively: "this is some really long con..." where the content is truncated and replaced a final trailing three periods (possible actual ellipses) Also, are you sure you are not sending this to a pager? David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Displaying-a-wide-column-with-psql-tp5817275p5817285.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
