Re: Starting psql from Script - how to pass the password?

Поиск
Список
Период
Сортировка
От Hubert Lubaczewski
Тема Re: Starting psql from Script - how to pass the password?
Дата
Msg-id 20030620142204.18abb1f5.hubert.lubaczewski@eo.pl
обсуждение исходный текст
Ответ на Starting psql from Script - how to pass the password?  (Dani Oderbolz <oderbolz@ecologic.de>)
Ответы Re: Starting psql from Script - how to pass the password?
Список pgsql-novice
On Fri, 20 Jun 2003 13:22:50 +0200
Dani Oderbolz <oderbolz@ecologic.de> wrote:

> But still, psql prompts me for the password...
> Is there a way around this?

sure,
just:
export PGPASSWORD="your_password"
before calling postgresql programs.
than it doesn't ask.
but since it's raher dangerous, check if you can (version dependant), and use ~/.pgpass file instead.
you can find more information in postgresql-docs/html/libpq-envars.html

best regards

depesz


В списке pgsql-novice по дате отправления:

Предыдущее
От: Dani Oderbolz
Дата:
Сообщение: Starting psql from Script - how to pass the password?
Следующее
От: Dani Oderbolz
Дата:
Сообщение: Re: Starting psql from Script - how to pass the password?