From: Andy <frum@ar-sd.net>
To: pgsql-admin@postgresql.org
Subject: Problem Setting DateStyle
Date: Mon, 26 Jun 2006 16:55:51 +0300
Message-ID: <014601c69928$3dd35740$0b00a8c0@mpsro.dom> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: frum@ar-sd.net
Subject: Re: Problem Setting DateStyle
In-Reply-To: <014601c69928$3dd35740$0b00a8c0@mpsro.dom>
References: <014601c69928$3dd35740$0b00a8c0@mpsro.dom>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox