On 2011-01-28, Basil Bourque <basil(dot)list(at)me(dot)com> wrote:
> Is there a way to set a different time zone as the default for a session?
> By default, Postgres displays my data stored in "TIMESTAMP WITH TIME
> ZONE" columns' data as a local time for the time zone of the computer
> hosting the Postgres cluster.
>
> If my Postgres server is in Seattle, but my user is in New York, I
> want the times shown in New York time zone.
-- once per session.
SET TIMEZONE TO 'America/New_York';
-- or once only
ALTER USER username SET TIMEZONE TO 'America/New_York';
or you can do the whole database with ALTER DATABASE.
--
⚂⚃ 100% natural