| From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | timestamp |
| Date: | 2002-05-30 20:07:22 |
| Message-ID: | Pine.LNX.4.44.0205301302450.12535-100000@visor.corp.nextbus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
We currently have several tables that have columns defined as timestamp.
Does simply defining the column as timestamp imply "with time zone"?
This timestamp field contains data such as:
2002-05-28 07:19:41-04
However, when I pg_dump this table and then pg_restore it on another database, this
timestamp field now becomes:
2002-05-28 04:19:41-07
How do I maintain the same value for the timestamp fields when I restore
tables that have timestamp columns?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Where's my....bus?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2002-05-30 20:07:51 | Re: postgresql/php/apache installation question. |
| Previous Message | Scott Marlowe | 2002-05-30 19:58:10 | Re: connection refused problem |