View Single Post

   
  #3 (permalink)  
Old 04-16-2008, 01:51 AM
Oliver Jowett
 
Posts: n/a
Default Re: COPY <table> FROM STDIN BINARY

Владимир Баранов 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote