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

help / color / mirror / Atom feed
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 09:57:29 +0000
Message-ID: <422EC889.2070900@archonet.com> (raw)
In-Reply-To: <200503091517.20691.lawgon@thenilgiris.com>
References: <200503091135.55033.lawgon@thenilgiris.com>
	<200503091251.25413.lawgon@thenilgiris.com>
	<422EAF5C.1070305@archonet.com>
	<200503091517.20691.lawgon@thenilgiris.com>

Kenneth Gonsalves wrote:
> 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

http://www.postgresql.org/docs/7.4/static/sql-alterdatabase.html

Synopsis

ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT }
ALTER DATABASE name RESET parameter

-- 
   Richard Huxton
   Archonet Ltd



view thread (6+ messages)

Message-ID: <422EC889.2070900@archonet.com>
Permalink:  ../422EC889.2070900@archonet.com/
Also on:    postgresql.org/message-id/422EC889.2070900@archonet.com

 · 

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