| From: | Thomas Good <tomg(at)q8(dot)nrnet(dot)org> |
|---|---|
| To: | pgsql-novice(at)hub(dot)org |
| Subject: | changing datestyle |
| Date: | 2000-10-30 16:12:53 |
| Message-ID: | Pine.LNX.3.96.1001030111016.11953A-100000@q8.nrnet.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
--------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Davis | 2000-10-30 23:03:04 | Re: changing datestyle |
| Previous Message | James Hall | 2000-10-30 15:54:30 | Postgres not finding tables |