Re: [ADMIN] Datetypes

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." <johan(dot)f(dot)strand(at)telia(dot)se> 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
> johan(dot)f(dot)strand(at)telia(dot)se
>
> ************
>
>
>

--
Mattias Norlander
mattias(at)umc(dot)se