Displaying a wide column with psql - Mailing list pgsql-general

From Philip Rhoades
Subject Displaying a wide column with psql
Date
Msg-id a81e91e4474fca1dcb1c42defdc858aa@localhost
Whole thread Raw
Responses Re: Displaying a wide column with psql  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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?

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW    2001
Australia
E-mail:  phil@pricom.com.au






pgsql-general by date:

Previous
From: Patrick Krecker
Date:
Subject: Re: WAL receive process dies
Next
From: Adrian Klaver
Date:
Subject: Re: Displaying a wide column with psql