st 22. 5. 2024 v 21:13 odesílatel Ron Johnson <ronljohnso...@gmail.com> napsal:
> On Wed, May 22, 2024 at 1:58 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Ron Johnson <ronljohnso...@gmail.com> writes: >> > 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. >> >> ... and they're pwned within five minutes by any user with the wits >> to create a trojan-horse function or operator. Generally speaking, >> you want admins to run with a minimal search path not a maximal one. >> > > Missing tables when running "\t" is a bigger hassle. > what is hard on \dt *.* or you can define own dtall = '\\dt *.*' :dtall The problem is not on search path, but maybe on design backslash commands - but there should be some level of consistency Regards Pavel