From: | Roberto João Lopes Garcia <roberto(at)mha(dot)com(dot)br> |
---|---|
To: | Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: set DateStyle to 'SQL' |
Date: | 2002-07-26 18:16:57 |
Message-ID: | 5.1.1.6.0.20020726150420.01f45d60@ftp.mha.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Elielson Fontanezi | 2002-07-26 18:34:12 | 1 milion data insertion |
Previous Message | Elielson Fontanezi | 2002-07-26 17:09:29 | Numeric Style format |