Re: Making the datestyle be SQL on postmaster startup

An environment variable will do the trick..

PGDATESTYLE="postgres"
export PGDATESTYLE

-Mitch

----- Original Message -----
From: "Justin Yung" <justin(at)clearnow(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, March 01, 2001 2:17 PM
Subject: Making the datestyle be SQL on postmaster startup

>
> 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
>
>
>

----------------------------------------------------------------------------
----

>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>