Problem Setting DateStyle

From: "Andy" <frum(at)ar-sd(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Problem Setting DateStyle
Date: 2006-06-26 13:55:51
Message-ID: 014601c69928$3dd35740$0b00a8c0@mpsro.dom
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dennis Wagner 2006-06-26 14:05:33 Using GUIDs
Previous Message Sistemas C.M.P. 2006-06-26 13:49:50 PosgreSQL with Joomla