Date: Wed, 1 Mar 2006 14:26:07 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Change date format through an environmental variable?
Message-ID: <20060301192607.GM17356@phlogiston.dyndns.org>
References: <4405DAAA.4010908@noaa.gov> <4405F419.5080306@noaa.gov>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4405F419.5080306@noaa.gov>
User-Agent: Mutt/1.5.9i

On Wed, Mar 01, 2006 at 02:20:57PM -0500, Mark Fenbers wrote:
> 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?

That's a client variable, and it works for libpq-based clients that
don't do something funny with them (none of them ought to, but one
can't guarantee others' programs).  So you're not modifying for other
clients, AFAIK, just for you.  (If that's what you want, well, good,
but it's important to know what it does.)

The list for 8.1 is in the docs:

http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
		--Alexander Hamilton