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 053E79DC863 for ; Wed, 1 Mar 2006 14:32:31 -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 57439-05 for ; Wed, 1 Mar 2006 14:32:30 -0400 (AST) X-Greylist: delayed 00:59:59.786685 by SQLgrey- Received: from mmp3.nems.noaa.gov (mmp3.nems.noaa.gov [140.90.121.158]) by postgresql.org (Postfix) with ESMTP id 2645C9DC97D for ; Wed, 1 Mar 2006 14:32:29 -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 <0IVG00LA3M23F1@mmp3.nems.noaa.gov> for pgsql-sql@postgresql.org; Wed, 01 Mar 2006 12:32:29 -0500 (EST) Date: Wed, 01 Mar 2006 12:32:26 -0500 From: Mark Fenbers Subject: Change date format through an environmental variable? To: PostgreSQL - SQL Message-id: <4405DAAA.4010908@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) 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/17 X-Sequence-Number: 24363 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