Hi all,

Is there a way to specify the default format for a timsetamp field?

Specifically, what I am trying to do is to use COPY to get the data out of a table to 
be loaded into another database.  I would like the timestamp fields accuracy to be 
maintained (to at least 3 places for milliseconds).

Or even more specific, I want the COPY to be local to the client so I use stdout and 
redirect it to a file.  In order to keep the acuracy on the timestamp fields, I need 
to COPY BINARY.  This can not be used in conjunction with stdout.

Any suggestions?

-- 
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Reply via email to