Re: Request for comment on setting binary format output per session - Mailing list pgsql-hackers

On 20.03.23 18:04, Jeff Davis wrote:
> 2. Easy to confuse psql:
> 
>    CREATE TABLE a(d date, t timestamptz);
>    SET format_binary='25,1082,1184';
>    SELECT * FROM a;
>     d | t
>    ---+---
>     ! |
>    (1 row)

You can already send binary data to psql using DECLARE BINARY CURSOR. 
It might be sensible to have psql check that the data it is getting is 
text format before trying to print it.