public inbox for [email protected]
help / color / mirror / Atom feedsearch_path wildcard?
4+ messages / 3 participants
[nested] [flat]
* search_path wildcard?
@ 2024-05-22 16:35 Ron Johnson <[email protected]>
2024-05-22 16:53 ` Re: search_path wildcard? David G. Johnston <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Ron Johnson @ 2024-05-22 16:35 UTC (permalink / raw)
To: pgsql-general
This doesn't work, and I've found nothing similar:
ALTER ROLE foo SET SEARCH_PATH = '*';
Is there a single SQL statement which will generate a search path based
on information_schema.schemata, or do I have to write an anonymous DO
procedure?
SELECT schema_name FROM information_schema.schemata WHERE schema_name !=
'information_schema' AND schema_name NOT LIKE 'pg_%';
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: search_path wildcard?
2024-05-22 16:35 search_path wildcard? Ron Johnson <[email protected]>
@ 2024-05-22 16:53 ` David G. Johnston <[email protected]>
2024-05-22 17:54 ` Re: search_path wildcard? Ron Johnson <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2024-05-22 16:53 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: pgsql-general
On Wed, May 22, 2024, 10:36 Ron Johnson <[email protected]> wrote:
> This doesn't work, and I've found nothing similar:
> ALTER ROLE foo SET SEARCH_PATH = '*';
>
Correct, you cannot do that.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: search_path wildcard?
2024-05-22 16:35 search_path wildcard? Ron Johnson <[email protected]>
2024-05-22 16:53 ` Re: search_path wildcard? David G. Johnston <[email protected]>
@ 2024-05-22 17:54 ` Ron Johnson <[email protected]>
2024-05-22 19:34 ` Re: search_path wildcard? Pavel Stehule <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Ron Johnson @ 2024-05-22 17:54 UTC (permalink / raw)
To: pgsql-general
On Wed, May 22, 2024 at 12:53 PM David G. Johnston <
[email protected]> wrote:
> On Wed, May 22, 2024, 10:36 Ron Johnson <[email protected]> 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: search_path wildcard?
2024-05-22 16:35 search_path wildcard? Ron Johnson <[email protected]>
2024-05-22 16:53 ` Re: search_path wildcard? David G. Johnston <[email protected]>
2024-05-22 17:54 ` Re: search_path wildcard? Ron Johnson <[email protected]>
@ 2024-05-22 19:34 ` Pavel Stehule <[email protected]>
0 siblings, 0 replies; 4+ messages in thread
From: Pavel Stehule @ 2024-05-22 19:34 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: pgsql-general
st 22. 5. 2024 v 19:54 odesílatel Ron Johnson <[email protected]>
napsal:
> On Wed, May 22, 2024 at 12:53 PM David G. Johnston <
> [email protected]> wrote:
>
>> On Wed, May 22, 2024, 10:36 Ron Johnson <[email protected]> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-05-22 19:34 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-22 16:35 search_path wildcard? Ron Johnson <[email protected]>
2024-05-22 16:53 ` David G. Johnston <[email protected]>
2024-05-22 17:54 ` Ron Johnson <[email protected]>
2024-05-22 19:34 ` Pavel Stehule <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox