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