Displaying a wide column with psql

From: Philip Rhoades <phil(at)pricom(dot)com(dot)au>
To: sydpug(at)postgresql(dot)org
Subject: Displaying a wide column with psql
Date: 2014-08-27 10:49:23
Message-ID: 44cb7f66315f58ddfe6a4e65421df795@localhost
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: sydpug

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 "&hellip;"
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(at)pricom(dot)com(dot)au

Responses

Browse sydpug by date

  From Date Subject
Next Message David G Johnston 2014-08-27 14:01:14 Re: Displaying a wide column with psql
Previous Message Richard Sayad 2014-07-29 06:54:59 Sydpug presents PostgreSQL 9.4 New Features (Sponsored by Fujitsu)