An environment variable will do the trick..
PGDATESTYLE="postgres"
export PGDATESTYLE
-Mitch
----- Original Message -----
From: "Justin Yung" <justin@clearnow.com>
To: <pgsql-general@postgresql.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@postgresql.org
>