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