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 215979DC821 for ; Wed, 1 Mar 2006 14:47:13 -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 60482-08 for ; Wed, 1 Mar 2006 14:47:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8]) by postgresql.org (Postfix) with ESMTP id 1484F9DCC2E for ; Wed, 1 Mar 2006 14:47:09 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:40251 helo=phlogiston.dydns.org) by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD)) id 1FEWLu-000EXo-1j for pgsql-sql@postgresql.org; Wed, 01 Mar 2006 13:47:10 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 5DC084051; Wed, 1 Mar 2006 13:47:09 -0500 (EST) Date: Wed, 1 Mar 2006 13:47:09 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Change date format through an environmental variable? Message-ID: <20060301184709.GL17356@phlogiston.dyndns.org> References: <4405DAAA.4010908@noaa.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4405DAAA.4010908@noaa.gov> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.079 required=5 tests=[AWL=0.079] X-Spam-Score: 0.079 X-Spam-Level: X-Archive-Number: 200603/18 X-Sequence-Number: 24364 On Wed, Mar 01, 2006 at 12:32:26PM -0500, Mark Fenbers wrote: > 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. No, it won't work as an environment variable. You can alter the postgresql.conf file, though. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes