From: | "Justin Yung" <justin(at)clearnow(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Making the datestyle be SQL on postmaster startup |
Date: | 2001-03-01 19:17:54 |
Message-ID: | DKEMIOLLLHFPIIAADECFMECICCAA.justin@clearnow.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I'm wishing to set the datestyle in my databases to be of type SQL.
I can do this by the following command:
set datestyle = sql;
However, I'd like to do this automatically upon database startup.
I notice that "postmaster" has a potential configuration option that might
let me do this (note: -o):
-o BackendOptions
The postgres options specified in BackendOptions are passed to all backend
server processes started by this postmaster. If the option string contains
any spaces, the entire string must be quoted.
... but can't seem to find any examples of how this should be set. Any
ideas?
Thanks,
Justin
Attachment | Content-Type | Size |
---|---|---|
Justin Yung.vcf | text/x-vcard | 332 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-03-01 19:18:21 | Re: Set Operators and Arrays Question |
Previous Message | Denis Perchine | 2001-03-01 19:12:33 | Re: Postgres eats up memory when using cursors |