Horton

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

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

View thread
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Jeff Davis <pgsql@j-davis.com>, Dave Cramer <davecramer@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-03-22T09:14:28Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Silence compiler warning introduced in 1edb3b491b

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.