Re: Request for comment on setting binary format output per session

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>, Dave Cramer <davecramer(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Request for comment on setting binary format output per session
Date: 2023-03-22 09:14:28
Message-ID: f68b87ee-91e2-0130-d44b-65053ebe614c@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2023-03-22 09:21:17 Re: Request for comment on setting binary format output per session
Previous Message Peter Eisentraut 2023-03-22 09:12:12 Re: Request for comment on setting binary format output per session