| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: datestyle setting |
| Date: | 2005-03-09 09:57:29 |
| Message-ID: | 422EC889.2070900@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KÖPFERL Robert | 2005-03-09 10:39:01 | Re: [SQL] Postgres schema comparison. |
| Previous Message | Kenneth Gonsalves | 2005-03-09 09:47:20 | Re: datestyle setting |