| From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
|---|---|
| To: | "Crombleholme, Roy" <Roy(dot)Crombleholme(at)its(dot)lancscc(dot)gov(dot)uk> |
| Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: datestyle |
| Date: | 2003-05-16 18:50:07 |
| Message-ID: | 1053111007.666.12.camel@billy |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Am Fre, 2003-05-16 um 11.00 schrieb Crombleholme, Roy:
> Hi everyone,
>
> Got a small problem with dates on postgresql. if i connect to a database
> and then run the command: SET datestyle to european;
> The date gets set to ISO with european conventions but only for the current
> session. At the moment its default is ISO with US (non european)
> conventions.
>
> I need to be able to set the default to european. I put datestyle =
> european in the postgresql.conf file but postmaster complained about this
> and would not start up. Does anybody know the correct entry to achieve this
> or a postmaster -c "command"
I do this in debian
/etc/init.d/postgresql
su - postgres -c "PGDATESTYLE=GERMAN /usr/lib/postgresql/bin/postgresql-startup"
HIH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dario billo | 2003-05-16 19:27:53 | \copy command |
| Previous Message | Nabil Sayegh | 2003-05-16 18:41:02 | Re: SELECT across multiple db |