Re: set DateStyle to 'SQL'

Hi

I think you want to see dates like: 26/07/2002, that is dd/mm/yyyy

To get it I set the enviroment variable  PGDATESTYLE to SQL,European in the profile script

PGDATESTYLE=SQL,European

It can also be set in psql like bellow:

=# set DATESTYLE to SQL; set DATESTYLE to European;

Roberto


At 10:27 26/07/2002, you wrote:
>Hi folks!
>
>        There are a buch of varibles like DateStyle. I am interested to set
>them
>all in script shell.
>        I've tried in postgresql.conf, but I could not.
>        I've tried in shell environment, but it did not work.
>
>        So, how can I do that?
>
>..............................................
>A Question...
>Since before your sun burned hot in space and before your race was born, I
>have awaited a question.
>
>Elielson Fontanezi 
>DBA Technical Support - PRODAM
>+55 11 5080 9493
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org