Re: search_path wildcard? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: search_path wildcard?
Date
Msg-id CAFj8pRDg0UGkG9=LVRL2-mmJRTK2_KkEuzvzgBRqVDP2LZiR_A@mail.gmail.com
Whole thread Raw
In response to Re: search_path wildcard?  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general


st 22. 5. 2024 v 19:54 odesílatel Ron Johnson <ronljohnsonjr@gmail.com> napsal:
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.

It can be pretty dangerous, because you don't specify order of schemas 

Regards

Pavel

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: search_path wildcard?
Next
From: Ron Johnson
Date:
Subject: Re: search_path and SET ROLE