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.
pgsql-admin by date
|Next:||From: Dennis Wagner||Date: 2006-06-26 14:05:33|
|Subject: Using GUIDs|
|Previous:||From: Sistemas C.M.P.||Date: 2006-06-26 13:49:50|
|Subject: PosgreSQL with Joomla|