Making the datestyle be SQL on postmaster startup

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

Responses

Browse pgsql-general by date

  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