Unwanted time zone conversion

Поиск
Список
Период
Сортировка
От Rob Richardson
Тема Unwanted time zone conversion
Дата
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBD1FDA9969@RADCONWIN2K8PDC.radcon.local
обсуждение исходный текст
Ответы Re: Unwanted time zone conversion  (Rob Richardson <RDRichardson@rad-con.com>)
Re: Unwanted time zone conversion  (Steve Crawford <scrawford@pinpointresearch.com>)
Список 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 по дате отправления:

Предыдущее
От: Daniel Staal
Дата:
Сообщение: Re: Text search language field
Следующее
От: Rob Richardson
Дата:
Сообщение: Re: Unwanted time zone conversion