Re: datestyle setting - Mailing list pgsql-sql

From Richard Huxton
Subject Re: datestyle setting
Date
Msg-id 422EC889.2070900@archonet.com
Whole thread Raw
In response to Re: datestyle setting  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List 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


pgsql-sql by date:

Previous
From: Kenneth Gonsalves
Date:
Subject: Re: datestyle setting
Next
From: KÖPFERL Robert
Date:
Subject: Re: [ADMIN] Postgres schema comparison.