Re: changing datestyle

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
>--------------------------------------------------------------------
>