I use this to start up my postmaster:
su - postgres -c 'export PGDATESTYLE=ISO; postmaster -N 32 -B 256 -i -o "-S 16535 -F"
2>>/var/log/pglog >>/var/log/pglog' >>/dev/null&
... which sets the datestyle to ISO.
There is also a sql command called "SET DATESTYLE" but I can't get it to work though...
"Strand Johan F." <[EMAIL PROTECTED]> writes:
> Hello there !
>
> How do I do if I want to change the variable
> DATETYPES or PGDATESTYLE to ISO.
> I want to se my date column like this 2000-01-12
> and not 01-12-2000 when I do a select on it.
>
> Thanks
>
> /Johan
> [EMAIL PROTECTED]
>
> ************
>
>
>
--
Mattias Norlander
[EMAIL PROTECTED]
************
