Re: very long record lines in expanded psql output
Platon Pronko <platon7pronko@gmail.com>
From: Platon Pronko <platon7pronko@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-08-05T18:56:20Z
Lists: pgsql-hackers
> it can be a fully new format - designed for simple copy from terminal. Some
> like
>
> ====== record: 10 ======
> ------------ proname ------------
> left
> ------------ prosrc ------------
> $lalalal
> ewqrwqerw
> ewqrwqerqrewq
> $
> ===============
> no, it was proposed for psql
How is this better than "copy (...) to stdout"? E.g.:
$ copy (select * from pg_class limit 1) to stdout;
2619 pg_statistic 11 12016 0 10 2 2619 0 18 402 18 2840 t f p r 31 0 f f f f f t n f0 478 1 {postgres=arwdDxt/postgres} \N \N
You can still copy the necessary parts (using mouse selection) -
seems that it achieves the the same goal.
Best regards,
Platon Pronko
Commits
-
psql: Tweak xheader_width and pager_min_lines input parsing
- ed7e686a031e 16.0 landed
-
Add xheader_width pset option to psql
- a45388d6e098 16.0 landed