Long wrapped header lines in psql with expanded mode (9.6.3)

From: Simon Ruderich <simon(at)ruderich(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Long wrapped header lines in psql with expanded mode (9.6.3)
Date: 2017-07-13 12:40:57
Message-ID: 20170713124057.rmjkte5lzm5gc3dg@ruderich.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm using the following minimal ~/.psqlrc:

\pset expanded on

Now when I select rows from a table which are too long to fit the
screen then I get this output:

simon=> table test;
-[ RECORD 1 ]---------------------------------------
----------------------------------------------------
----------------------------------------------------
-------------------------------------------------
test | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
-[ RECORD 2 ]---------------------------------------
----------------------------------------------------
----------------------------------------------------
-------------------------------------------------
test | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Is there any way to remove the superfluous header lines? I'd like
to get the following output which doesn't waste so much screen
space:

simon=> table test;
-[ RECORD 1 ]---------------------------------------
test | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
-[ RECORD 2 ]---------------------------------------
test | aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

Regards
Simon
--
+ privacy is necessary
+ using gnupg http://gnupg.org
+ public key id: 0x92FEFDB7E44C32F9

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2017-07-13 13:37:25 Re: Changing collate & ctype for an existing database
Previous Message Gregory Nicol 2017-07-13 09:46:59 LDAP authentication without OU in ldapbasedn