Re: environment variables
От
Michael Fuhr
Тема
Re: environment variables
Дата
Msg-id
20050321033552.GA16885@winnie.fuhr.org
Ответ на
environment variables (Walker, Jed S)
Список
Дерево обсуждения
environment variables "Walker, Jed S" <Jed_Walker@cable.comcast.com>
Re: environment variables Michael Fuhr <mike@fuhr.org>
Re: environment variables Tom Lane <tgl@sss.pgh.pa.us>
On Thu, Mar 17, 2005 at 12:57:16PM -0700, Walker, Jed S wrote: > I've noticed postgres uses some environment variables such as $PGDATA. Is > there a standard postgres environment variable for the current database? > > I'd like something where we can have aliases and such access the db without > the user having to know what the name is > > alias sql='psql -d $PGDATABASE' PGDATABASE should work. Did you try setting it as an environment variable? That is, using "export" or "setenv", depending on what shell you're using? See "Environment" in the psql documentation and "Environment Variables" in the libpq documentation. Here are links to doc for the latest release: http://www.postgresql.org/docs/8.0/interactive/app-psql.html http://www.postgresql.org/docs/8.0/interactive/libpq-envars.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/
В списке pgsql-novice по дате отправления
