X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id B9ADA9DC9AE
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Mar 2006 15:21:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 72610-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Mar 2006 15:21:01 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mmp3.nems.noaa.gov (mmp3.nems.noaa.gov [140.90.121.158])
	by postgresql.org (Postfix) with ESMTP id 09DA39DC97D
	for <pgsql-sql@postgresql.org>; Wed,  1 Mar 2006 15:20:58 -0400 (AST)
Received: from [198.206.42.50] (hopper.wiln.noaa.gov [198.206.42.50])
	by mmp3.nems.noaa.gov
	(iPlanet Messaging Server 5.2 HotFix 2.01 (built Aug 26 2004))
	with ESMTPSA id <0IVG00LIUR2XF1@mmp3.nems.noaa.gov> for
	pgsql-sql@postgresql.org; Wed, 01 Mar 2006 14:21:00 -0500 (EST)
Date: Wed, 01 Mar 2006 14:20:57 -0500
From: Mark Fenbers <Mark.Fenbers@noaa.gov>
Subject: Re: Change date format through an environmental variable?
In-reply-to: <4405DAAA.4010908@noaa.gov>
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Message-id: <4405F419.5080306@noaa.gov>
Organization: DOC/NOAA/NWS/OHRFC
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
User-Agent: Thunderbird 1.5 (Windows/20051201)
References: <4405DAAA.4010908@noaa.gov>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120]
X-Spam-Score: 0.12
X-Spam-Level: 
X-Archive-Number: 200603/19
X-Sequence-Number: 24365

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
>