Unwanted time zone conversion - Mailing list pgsql-novice

From Rob Richardson
Subject Unwanted time zone conversion
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBD1FDA9969@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
Responses Re: Unwanted time zone conversion
Re: Unwanted time zone conversion
List pgsql-novice

Greetings!

 

I am in the eastern US trying to track down events that occurred at a customer site in Vietnam.  I decided it would be easier to look at their database on my machine instead of wrestling with a VNC connection half way around the world.  So, I used PGAdmin to take a backup of their database, and then I restored it onto my computer.  The table I’m interested in now has a column named event_date of type timestamp with time zone.  On the customer’s computer, the time zone is +07.  On my computer, the time zone is -04. 

 

Is there a way to restore the database onto my computer, leaving the time zone in that column unchanged?

 

Thank you very much!

 

RobR

pgsql-novice by date:

Previous
From: Daniel Staal
Date:
Subject: Re: Text search language field
Next
From: Rob Richardson
Date:
Subject: Re: Unwanted time zone conversion