Re: Change date format through an environmental variable?

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)