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