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

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: 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-20 18:41:15
Message-ID: ed00e18b605acd3d3e5e582fd6e438f676f4482a.camel@j-davis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 2023-03-20 at 10:04 -0700, Jeff Davis wrote:
>   CREATE TABLE a(d date, t timestamptz);
>   SET format_binary='25,1082,1184';
>   SELECT * FROM a;
>    d | t
>   ---+---
>    ! |
>   (1 row)

Oops, missing the following statement after the CREATE TABLE:

INSERT INTO a VALUES('1234-01-01', '2023-03-20 09:00:00');

Regards,
Jeff Davis

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark (as CFM) 2023-03-20 18:47:24 Re: doc: add missing "id" attributes to extension packaging page
Previous Message Gregory Stark (as CFM) 2023-03-20 18:40:43 Re: [PATCH] psql: Add tab-complete for optional view parameters