Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: <rodrigo(dot)sakai(at)zanthus(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: RESTORING A DATABASE WITH DIFFERENT TIMEZONES
Date: 2006-12-21 17:08:26
Message-ID: F69F4496-CEE1-487F-BBB6-B3C1AAA06B65@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Dec 21, 2006, at 11:32 , Rodrigo Sakai wrote:
> But I have to restore it and maintain the same value of datetime!
> How can I do it?????

You should have no problem. A timestamp with time zone marks an
absolute instant in time: the different time zones are different
representations of the same instant.

Michael Glaesemann
grzm seespotcode net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2006-12-21 17:17:53 TSearch2 Changeset 25387
Previous Message Matthew T. O'Connor 2006-12-21 17:03:30 Re: Autovacuum Improvements