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
>
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, o
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:
> > > http://www.postgresql.org
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 abo
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 ...
reg
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
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
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
Mar
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 va
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 eff
10 matches
Mail list logo