From: Richard Huxton <dev@archonet.com>
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: datestyle setting
Date: Wed, 09 Mar 2005 08:10:04 +0000
Message-ID: <422EAF5C.1070305@archonet.com> (raw)
In-Reply-To: <200503091251.25413.lawgon@thenilgiris.com>
References: <200503091135.55033.lawgon@thenilgiris.com>
<20765.1110349646@sss.pgh.pa.us>
<200503091251.25413.lawgon@thenilgiris.com>
Kenneth Gonsalves wrote:
> On Wednesday 09 Mar 2005 11:57 am, Tom Lane wrote:
>>
>>If it's a reasonably recent version of PG, either ALTER DATABASE
>>SET or ALTER USER SET might serve.
>
>
> postgresql 7.4. when i type:
>
> alter database set datestyle to 'European'
>
> i get 'syntax error at or near "datestyle" at character 20'
I keep making this mistake, you need to include the database name:
ALTER DATABASE my_db_name SET datestyle TO 'ISO';
--
Richard Huxton
Archonet Ltd
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, lawgon@thenilgiris.com, tgl@sss.pgh.pa.us
Subject: Re: datestyle setting
In-Reply-To: <422EAF5C.1070305@archonet.com>
* 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