| From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | format timestamp |
| Date: | 2001-09-27 20:56:14 |
| Message-ID: | Pine.LNX.4.33.0109271352100.14923-100000@visor.corp.nextbus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2001-09-27 23:43:33 | Re: simple question! |
| Previous Message | Josh Berkus | 2001-09-27 18:22:55 | Re: LEFT OUTER JOIN problem |