Re: Setting DateStyle

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Self <jself(at)nngov(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Setting DateStyle
Date: 2002-10-22 20:11:03
Message-ID: 24989.1035317463@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jeff Self <jself(at)nngov(dot)com> writes:
> I'm trying to set my datestyle automatically in postgresql.conf this
> way:
> datestyle = 'iso, us'

That will work as of PG 7.3, but not in prior releases. (Datestyle and
a couple of other slightly-weird SET variables didn't get folded into
GUC until 7.3.) The workaround in old releases is to set PGDATESTYLE in
the postmaster's environment, instead.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-10-22 21:02:16 Re: Drop and reload table to clear corruption?
Previous Message Gabor Faludi 2002-10-22 19:01:59 security rights per database DDL/DML connect