From: Roberto João Lopes Garcia <roberto@mha.com.br>
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: set DateStyle to 'SQL'
Date: Fri, 26 Jul 2002 15:16:57 -0300
Message-ID: <5.1.1.6.0.20020726150420.01f45d60@ftp.mha.com.br> (raw)
In-Reply-To: <A799F7647794D311924A005004ACEA97080DDEB7@cprodamibs249.pro dam>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: roberto@mha.com.br, ElielsonF@prodam.sp.gov.br
Subject: Re: set DateStyle to 'SQL'
In-Reply-To: <5.1.1.6.0.20020726150420.01f45d60@ftp.mha.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox