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