Re: \pset xheader_width page as default? (Re: very long record lines in expanded psql output)

Christoph Berg <myon@debian.org>

From: Christoph Berg <myon@debian.org>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Platon Pronko <platon7pronko@gmail.com>, Zhihong Yu <zyu@yugabyte.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-08-30T14:36:49Z
Lists: pgsql-hackers
Re: Pavel Stehule
> pspg requires all lines to have the same width. It can do some corrections
> - but it is hard to detect wanted differences or just plain text format.
> 
> can be nice to have the first invisible row with some information about
> used formatting. pspg does some heuristic but this code is not nice and it
> is fragile.

I like pspg and use it myself, but I don't think a tool that does the
right thing by hiding a full screen of ---- from the user should
hinder making the same progress in psql with a simple pager.

Christoph



Commits

  1. psql: Tweak xheader_width and pager_min_lines input parsing

  2. Add xheader_width pset option to psql