Re: timestamp with time zone

On Dec 12, 2007 11:10 PM, Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
> Hi,
>
> Can someone enlighten me?
>
> I know that I can insert date/time data along with time zone info into
> the timestamp with time zone data type. My question is, can I extract
> the *original* time zone info afterward? I seems impossible.

Yep, that's correct.  Basically, when you store a timestamp with
timezone, postgresql converts it to UTC and stores that.  when you get
it back, it converts it to the timezone of the client currently
connected. If you want to store the timezone you'll have to create
another field to hold that.