Re: [SQL] Change date format through an environmental variable?

2006-03-02 Thread Peter Eisentraut
Am Donnerstag, 2. März 2006 08:33 schrieb Michael Fuhr: I see LC_COLLATE and LC_CTYPE in a few places but not in the documentation for postgres/postmaster, which is where they appear to be used (backend/main/main.c). Should those pages mention them? No, these variables are not used there,

Re: [SQL] Change date format through an environmental variable?

2006-03-02 Thread george young
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 [EMAIL PROTECTED] threw this fish to the penguins: I want to get Pg (v7.4.7) to output a date field in a different format

[SQL] Change date format through an environmental variable?

2006-03-01 Thread Mark Fenbers
I want to get Pg (v7.4.7) to output a date field in a different format than -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

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Andrew Sullivan
On Wed, Mar 01, 2006 at 12:32:26PM -0500, Mark Fenbers wrote: 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. No, it won't work as an environment

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Mark Fenbers
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

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Andrew Sullivan
On Wed, Mar 01, 2006 at 02:20:57PM -0500, Mark Fenbers wrote: 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

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Michael Fuhr
On Wed, Mar 01, 2006 at 02:20:57PM -0500, Mark Fenbers wrote: 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

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Tom Lane
Michael Fuhr [EMAIL PROTECTED] writes: The libpq documentation has a list of environment variables, although it's not complete: http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html Er, what's not complete about it? Feel free to send a doc patch ...

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Michael Fuhr
On Thu, Mar 02, 2006 at 01:16:47AM -0500, Tom Lane wrote: Michael Fuhr [EMAIL PROTECTED] writes: The libpq documentation has a list of environment variables, although it's not complete: http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html Er, what's not complete about it?

Re: [SQL] Change date format through an environmental variable?

2006-03-01 Thread Michael Fuhr
On Thu, Mar 02, 2006 at 12:33:31AM -0700, Michael Fuhr wrote: On Thu, Mar 02, 2006 at 01:16:47AM -0500, Tom Lane wrote: Michael Fuhr [EMAIL PROTECTED] writes: The libpq documentation has a list of environment variables, although it's not complete: