Re: set permanent date style

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Martin Teoh" <martin_teoh(at)hotmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: set permanent date style
Date: 2002-06-17 14:58:23
Message-ID: NEBBLAAHGLEEPCGOBHDGIEGBFCAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Martin-

in postmaster.conf, add a line that looks something like this:

PGDATESTYLE=ISO,European

(or SQL,European or POSTGRES,European or GERMAN,European)

Regards,

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Martin Teoh
> Sent: Friday, June 14, 2002 10:42 PM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] set permanent date style
>
>
> hi,
>
> I just install postgres 7.2.1 and start the server using the
> start up script
> provided in contrib/start-scripts/linux. Now I want my date style to
> automatically change to European every time the postgres server
> is started.
> How can I do it?
>
> Thanks,
> Martin
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ragnar Kjørstad 2002-06-17 15:11:50 Re: set permanent date style
Previous Message Jeff Boes 2002-06-17 14:02:58 Postgres and mod_perl: table locked during vacuum?