Re: datestyle

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