| From: | Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov> |
|---|---|
| To: | PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Change date format through an environmental variable? |
| Date: | 2006-03-01 19:20:57 |
| Message-ID: | 4405F419.5080306@noaa.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I found PGDATESTYLE that solves my problem, but ever since, I've been
looking for a comprehensive list of environmental variables that Pg
recognizes, but haven't been able to find such a list in any of the
books I looked in or the man pages. Anyone know where I can find such a
list?
Mark
Mark Fenbers wrote:
> I want to get Pg (v7.4.7) to output a date field in a different format
> than yyyy-mm-dd through the use of an environmental variable (because
> I have no access the SQL). Is this possible? I know about the
> DATESTYLE variable, but that seems to work only within a query
> transaction, and has no effect if trying to set it as an envvar.
>
> Mark
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2006-03-01 19:26:07 | Re: Change date format through an environmental variable? |
| Previous Message | Andrew Sullivan | 2006-03-01 18:47:09 | Re: Change date format through an environmental variable? |