Re: How to? Timestamp with timezone.

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Andre Lopes <lopes80andre(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: How to? Timestamp with timezone.
Date: 2010-03-10 12:46:49
Message-ID: 20100310124649.GA3418@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andre Lopes escribió:
> Hi,
>
> Thanks for the reply's.
>
> [code]
> ALTER DATABASE foo SET timezone TO 'someval'
> ALTER ROLE bar SET timezone TO 'someval'
> [/code]
>
> I need to alter only the Timezone of the database OR I need also to alter
> the Role?

One of them suffices.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Kussama 2010-03-10 14:37:20 Re: regexp_replace puzzle
Previous Message Harald Fuchs 2010-03-10 12:41:54 regexp_replace puzzle