Skip site navigation (1) Skip section navigation (2)

Re: changing datestyle

From: Jason Davis <jdavis(at)tassie(dot)net(dot)au>
To: Thomas Good <tomg(at)q8(dot)nrnet(dot)org>
Cc: pgsql-novice(at)hub(dot)org
Subject: Re: changing datestyle
Date: 2000-10-30 23:03:04
Message-ID: 200010302302.KAA15128@zeus.tassie.net.au (view raw or flat)
Thread:
Lists: pgsql-novice
Hi 

I had the same problem with my web database stuff. The trick is to put the
line

SetEnv PGDATESTYLE Postgres

in your apache.conf (assuming you are running apache). Seems to be fussy
where it goes - works if you put it directly above the User and Group
directives.

A postmaster restart will be necessary.

regards,

Jason Davis
Database Administrator/Programmer
Tas Access
www.tassie.net.au


At 11:12 AM 30/10/2000 -0500, you wrote:
>Hi all.
>
>This ISO datestyle is a nuisance.  In my /etc/profile I am exporting
>an env var:  export PGDATESTYLE='postgres'
>
>This converts the date back to what ppl here are used to...but it
>does not work for the web server and the nobody user.
>
>Do I have to manually SET the variable before every SELECT ???
>Geez, I hope not...
>
>Thanks,
>Tom
>
>--------------------------------------------------------------------
>               SVCMC - Center for Behavioral Health                  
>--------------------------------------------------------------------
>Thomas Good                          tomg@ { admin | q8 } .nrnet.org
>IS Coordinator / DBA                 Phone: 718-354-5528 
>                                     Fax:   718-354-5056  
>--------------------------------------------------------------------
>Powered by:  PostgreSQL     s l a c k w a r e          FreeBSD:
>               RDBMS       |---------- linux      The Power To Serve
>--------------------------------------------------------------------
> 


In response to

Responses

pgsql-novice by date

Next:From: andrea gelminiDate: 2000-10-31 07:46:54
Subject: ehm... drop column...
Previous:From: Thomas GoodDate: 2000-10-30 16:12:53
Subject: changing datestyle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group