Re: How to? Timestamp with timezone.

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to? Timestamp with timezone.
Date: 2010-03-09 22:36:40
Message-ID: 4B96CD78.3040404@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andre Lopes wrote:
> It is possible to do this in a shared database server?
>

sure, client timezone is a per connection setting.

SET TIME ZONE 'WET';

or

SET TIME ZONE 'Europe/Lisbon';

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-03-09 22:48:41 Re: warm standby possible with 8.1?
Previous Message Andre Lopes 2010-03-09 22:07:03 Re: How to? Timestamp with timezone.