Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Dennis WagnerDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group