From: Mark Fenbers <Mark.Fenbers@noaa.gov>
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Subject: Re: Change date format through an environmental variable?
Date: Wed, 01 Mar 2006 14:20:57 -0500
Message-ID: <4405F419.5080306@noaa.gov> (raw)
In-Reply-To: <4405DAAA.4010908@noaa.gov>
References: <4405DAAA.4010908@noaa.gov>
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
>
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: Mark.Fenbers@noaa.gov
Subject: Re: Change date format through an environmental variable?
In-Reply-To: <4405F419.5080306@noaa.gov>
* 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