]Jean-Michel Chabanne wrote:
> evon600c wrote:
> > Hello,
> > Is there a simple way to configure the postgres server so that it always
> > understand the french date format 'dd/mm/yyyy' ?
> > Or is there a call i can perform in my client application that could
> > have the same effect ?
> >
> > I wish i had not to set some easy forgetable environment variables such
> > as LC_TIME.
> >
> > For instance in SQL Server i was able to issue a "set dateformat 'dmy'"
> > in the begining of all my transactions to get it done and that was fine
> > for me (and my customers...)
> >
> > Many thank's in advance.
>
> Wen connected you may do SET DateStyle = 'SQL,European';
>
> Or, with pgsql, before the connection you may export the variable
> PGDATESTYLE='SQL,European'
>
> This should work fine, but I have noticed that it does not work on one
> of my DB and I don't know why.
You can use set datestyle in postgresql.conf in 7.3.X. In 7.2, it had
to be an environment variable before the postmaster started, or us SET
as a command.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073