Re: datestyle setting

Kenneth Gonsalves wrote:
> On Wednesday 09 Mar 2005 11:57 am, Tom Lane wrote:
>>
>>If it's a reasonably recent version of PG, either ALTER DATABASE
>>SET or ALTER USER SET might serve.
> 
> 
> postgresql 7.4. when i type:
> 
> alter database set datestyle to 'European'
> 
> i get 'syntax error at or near "datestyle" at character 20'

I keep making this mistake, you need to include the database name:  ALTER DATABASE my_db_name SET datestyle TO 'ISO';

--   Richard Huxton  Archonet Ltd