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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org