Re: Making the datestyle be SQL on postmaster startup
От | Mitch Vincent |
---|---|
Тема | Re: Making the datestyle be SQL on postmaster startup |
Дата | |
Msg-id | 00a501c0a326$b2999bf0$0200000a@windows обсуждение исходный текст |
Ответ на | Making the datestyle be SQL on postmaster startup ("Justin Yung" <justin@clearnow.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: