Message-Id: <5.1.1.6.0.20020726150420.01f45d60@ftp.mha.com.br>
Date: Fri, 26 Jul 2002 15:16:57 -0300
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
From: Roberto =?iso-8859-1?Q?Jo=E3o?= Lopes Garcia <roberto@mha.com.br>
Subject: Re: set DateStyle to 'SQL'
Cc: pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <A799F7647794D311924A005004ACEA97080DDEB7@cprodamibs249.pro dam>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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