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?