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

Reply via email to