pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Kenneth Gonsalves <lawgon@thenilgiris.com>
To: Richard Huxton <dev@archonet.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: datestyle setting
Date: Wed, 9 Mar 2005 15:17:20 +0530
Message-ID: <200503091517.20691.lawgon@thenilgiris.com> (raw)
In-Reply-To: <422EAF5C.1070305@archonet.com>
References: <200503091135.55033.lawgon@thenilgiris.com>
	<200503091251.25413.lawgon@thenilgiris.com>
	<422EAF5C.1070305@archonet.com>

On Wednesday 09 Mar 2005 1:40 pm, Richard Huxton wrote:

>
> I keep making this mistake, you need to include the database name:
>    ALTER DATABASE my_db_name SET datestyle TO 'ISO';

er ... doesnt seem to be in the docs? Anyway it worked, thanx

-- 
regards
kg

http://www.livejournal.com/users/lawgon
tally ho! http://avsap.sourceforge.net
ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!

view thread (6+ messages)  latest in thread

Message-ID: <200503091517.20691.lawgon@thenilgiris.com>
Permalink:  ../200503091517.20691.lawgon@thenilgiris.com/
Also on:    postgresql.org/message-id/200503091517.20691.lawgon@thenilgiris.com

copy link · copy postgr.es

reply

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: lawgon@thenilgiris.com, dev@archonet.com, tgl@sss.pgh.pa.us
  Subject: Re: datestyle setting
  In-Reply-To: <200503091517.20691.lawgon@thenilgiris.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