From: george young <gry@ll.mit.edu>
To: pgsql-sql@postgresql.org
Subject: Re: Change date format through an environmental variable?
Date: Thu, 2 Mar 2006 10:33:10 -0500
Message-ID: <20060302103310.5ea5ccad.gry@ll.mit.edu> (raw)
In-Reply-To: <4405DAAA.4010908@noaa.gov>
References: <4405DAAA.4010908@noaa.gov>
Try the PGDATESTYLE environment variable.
Works in 7.4 and 8.1, though it is claimed to be deprecated.
-- George Young
On Wed, 01 Mar 2006 12:32:26 -0500
Mark Fenbers <Mark.Fenbers@noaa.gov> threw this fish to the penguins:
> 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
>
--
"Are the gods not just?" "Oh no, child.
What would become of us if they were?" (CSL)
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: gry@ll.mit.edu
Subject: Re: Change date format through an environmental variable?
In-Reply-To: <20060302103310.5ea5ccad.gry@ll.mit.edu>
* 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