| From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp |
| Date: | 2002-05-30 20:46:08 |
| Message-ID: | Pine.LNX.4.44.0205301345220.12937-100000@visor.corp.nextbus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ok, I figured it out...using the PGTZ environment variable.
Sorry for the un-necessary post.
L.
On Thu, 30 May 2002, Laurette Cisneros wrote:
>
> 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 | Cornelia Boenigk | 2002-05-30 21:03:20 | Re: postgresql/php/apache installation question. |
| Previous Message | Thomas Quinot | 2002-05-30 20:40:36 | Re: Is there a way to check if a db connection handle is still valid? |