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

2017-07-13 14:40 GMT+02:00 Simon Ruderich <simon(at)ruderich(dot)org>:

> 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
>

what about \pset format wrapped

Regards

Pavel

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