pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Change date format through an environmental variable?
Date: Wed, 1 Mar 2006 14:26:07 -0500
Message-ID: <20060301192607.GM17356@phlogiston.dyndns.org> (raw)
In-Reply-To: <4405F419.5080306@noaa.gov>
References: <4405DAAA.4010908@noaa.gov>
	<4405F419.5080306@noaa.gov>

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



view thread (10+ messages)  latest in thread

Message-ID: <20060301192607.GM17356@phlogiston.dyndns.org>
Permalink:  ../20060301192607.GM17356@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20060301192607.GM17356@phlogiston.dyndns.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: Change date format through an environmental variable?
  In-Reply-To: <20060301192607.GM17356@phlogiston.dyndns.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox