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