Re: datestyle setting

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