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