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