Re: Scripts Importing and Authentication

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Scripts Importing and Authentication
Дата
Msg-id 17120.1076134858@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Scripts Importing and Authentication  ("Enio Schutt Junior" <enio@pmpf.rs.gov.br>)
Список pgsql-admin
"Enio Schutt Junior" <enio@pmpf.rs.gov.br> writes:
> So, is there a way of making the import of a script without
> having to supply passwords of all different users contained
> in that script?

You want the script to use SET SESSION AUTHORIZATION instead of
\connect.  As of PG 7.4 this is the default; for a release or two
beforehand, there's some arcane option you can specify to pg_dump.

            regards, tom lane

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