Subject: Re: very long record lines in expanded psql output
To: Pavel Stehule <pavel.stehule@gmail.com>,
 Platon Pronko <platon7pronko@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: <f03d38a3-db96-a56e-d1bc-dbbc80bbde4d@gmail.com>
 <CAFj8pRBJ8bcTga9qTYG_v25BfeCB=4+GNc1rbf94qex_3C_e-A@mail.gmail.com>
 <998a8549-f808-a349-bae6-9f44d07e050d@dunslane.net>
 <d5280c71-b11b-b0fc-f57d-5033a9197406@gmail.com>
 <bf64d7b0-413d-1501-00b2-992491b865b0@dunslane.net>
 <4e8b9a10-95aa-aecf-01a1-cbc24d643465@gmail.com>
 <CAFj8pRCZwOXDmcHQ5tKt-ukduSRzPmu2-svouCEDQ+LCFXSmfw@mail.gmail.com>
From: Andrew Dunstan <andrew@dunslane.net>
Message-ID: <7f514232-8e2b-80b7-df2a-d86ea92b4176@dunslane.net>
Date: Thu, 5 Aug 2021 16:18:05 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.4.0
MIME-Version: 1.0
In-Reply-To: 
 <CAFj8pRCZwOXDmcHQ5tKt-ukduSRzPmu2-svouCEDQ+LCFXSmfw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/7f514232-8e2b-80b7-df2a-d86ea92b4176%40dunslane.net>
Precedence: bulk


On 8/5/21 2:25 PM, Pavel Stehule wrote:
>
>
> čt 5. 8. 2021 v 18:48 odesílatel Platon Pronko
> <platon7pronko@gmail.com <mailto:platon7pronko@gmail.com>> napsal:
>
>     Hi!
>     >>> I also find this annoying and would be happy to be rid of it.
>     >>
>     >> Have you tried "\pset format wrapped"? Pavel suggested it, and it
>     >> solved most of the problem for me, for example.
>     >
>     > Yes, but it changes the data line output. Ideally, you should be
>     able
>     > to  modify these independently.
>
>     I agree, and I think this can be implemented, but I'm a bit afraid of
>     introducing an additional psql option (there's already quite a lot
>     of them).
>     I suspect primary PostgreSQL maintainers won't be happy with such
>     an approach.
>
>
> it can be a fully new format - designed for simple copy from terminal.
> Some like
>
> ====== record: 10 ======
> ------------ proname ------------
> left
> ------------ prosrc  ------------
> $lalalal
> ewqrwqerw
> ewqrwqerqrewq
> $
> ===============
>
>

I think that's really a different idea. The original proposal was simply
to deal with insanely long header lines. This seems like massive scope
creep.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com