Re: datestyle setting

From: Richard Huxton <dev(at)archonet(dot)com>
To: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: datestyle setting
Date: 2005-03-09 09:57:29
Message-ID: 422EC889.2070900@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kenneth Gonsalves wrote:
> On Wednesday 09 Mar 2005 1:40 pm, Richard Huxton wrote:
>
>
>>I keep making this mistake, you need to include the database name:
>> ALTER DATABASE my_db_name SET datestyle TO 'ISO';
>
>
> er ... doesnt seem to be in the docs? Anyway it worked, thanx

http://www.postgresql.org/docs/7.4/static/sql-alterdatabase.html

Synopsis

ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET parameter

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message KÖPFERL Robert 2005-03-09 10:39:01 Re: [SQL] Postgres schema comparison.
Previous Message Kenneth Gonsalves 2005-03-09 09:47:20 Re: datestyle setting