Re: search_path wildcard?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: search_path wildcard?
Дата
Msg-id CANzqJaCjWr3Z3typ-Ye8vitiiYQEkCGz=w4Sx9Up7dZ+Hsb6Fw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: search_path wildcard?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: search_path wildcard?
Re: search_path wildcard?
Список pgsql-general
On Wed, May 22, 2024 at 12:53 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, May 22, 2024, 10:36 Ron Johnson <ronljohnsonjr@gmail.com> wrote:
This doesn't work, and I've found nothing similar:
ALTER ROLE foo SET SEARCH_PATH  = '*';

Correct, you cannot do that.

That would be a helpful feature for administrators, when there are multiple schemas in multiple databases, on multiple servers: superusers get ALTER ROLE foo SET SEARCH_PATH  = '*'; and they're done with it.

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: search_path and SET ROLE
Следующее
От: Tom Lane
Дата:
Сообщение: Re: search_path wildcard?