Problem Setting DateStyle

["Andy" <frum(at)ar-sd(dot)net>]

I want to have the DD/MM/YYYY date format in my database without to specify it with:

SET DateStyle='SQL, DMY' at every query.

 

I tried to modify it in postgres.conf >>> datestyle = 'European' or datestyle = 'SQL, DMY'

and I tried to make

alter database test5 SET DateStyle='SQL, DMY';

 

.... none of these worked.

 

If I run in a session

SET DateStyle='SQL, DMY'

then it is ok for that session.

 

How can I make it default for the whole system or at least for some databases?

 

OS: Suse 10, pgsql 8.0.3.

 

Regards,

 

Andy.