Displaying a wide column with psql

From: Philip Rhoades <phil(at)pricom(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Displaying a wide column with psql
Date: 2014-09-02 03:05:08
Message-ID: a81e91e4474fca1dcb1c42defdc858aa@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 "&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 pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-09-02 03:23:07 Re: Displaying a wide column with psql
Previous Message Patrick Krecker 2014-09-01 23:53:03 Re: WAL receive process dies