| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: setting default date format |
| Date: | 2003-10-01 10:46:57 |
| Message-ID: | 1065005217.2920.11.camel@linda.lfix.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2003-10-01 at 11:34, Gary Stainburn wrote:
> > In postgresql.conf:
> >
> > DATESTYLE = 'Postgres,European'
> When I did this, and then did 'service postgresql restart' the service failed
> to start.
> BTW, I'm running 7.2.3 from the RH RPMS.
The feature is available in 7.3
In 7.2 I seem to remember you can set an environemntal variable
PGDATESTYLE when starting psql, and you may be able to use SET:
SET DATESTYLE TO 'Postgres,European';
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Yet if any man suffer as a Christian, let him not be
ashamed; but let him glorify God on this behalf."
I Peter 4:16
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-10-01 13:44:35 | Re: Upgrade 7.2.1 to 7.3.4 datetime Error |
| Previous Message | Gary Stainburn | 2003-10-01 10:34:53 | Re: setting default date format |