pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedset DateStyle to 'SQL'
2+ messages / 2 participants
[nested] [flat]
* set DateStyle to 'SQL'
@ 2002-07-26 13:27 Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
0 siblings, 0 replies; 2+ messages in thread
From: Elielson Fontanezi @ 2002-07-26 13:27 UTC (permalink / raw)
To: pgsql-general <pgsql-general@postgresql.org>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: set DateStyle to 'SQL'
@ 2002-07-26 18:16 Roberto João Lopes Garcia <roberto@mha.com.br>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto João Lopes Garcia @ 2002-07-26 18:16 UTC (permalink / raw)
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>; +Cc: 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@postgresql.org
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-26 18:16 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-26 13:27 set DateStyle to 'SQL' Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
2002-07-26 18:16 Re: set DateStyle to 'SQL' Roberto João Lopes Garcia <roberto@mha.com.br>
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