Re: COPY FROM STDIN BINARY - Mailing list pgsql-jdbc
From Oliver Jowett
Subject Re: COPY FROM STDIN BINARY
Date
Msg-id 46C8B8C7.8090402@opencloud.com
Whole thread Raw
In response to COPY FROM STDIN BINARY  (Владимир Баранов<baranoff@inbox.ru>)
List pgsql-jdbc
Владимир Баранов wrote:

> My question is: what input binary format of a timestamp value should I use?

There are two possible formats depending on whether or not
integer_datetimes is set or not. (This is a compile-time option, you can
query the server to see which is set via SHOW, I think -- it's also
autoreported on connection startup, but you can't get at that as a JDBC
client)

I can't remember the details of the formats though -- you may need to
check the server source code for details. One is a 64-bit integer from
memory.

-O

pgsql-jdbc by date:

Previous
From: "Kalle Hallivuori"
Date:
Subject: Re: COPY FROM STDIN BINARY
Next
From: "Kathy Lo"
Date:
Subject: "pg_toast_2772_index" problem