Обсуждение: format timestamp

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.
Iwould 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
tokeep 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