Ron Johnson <ronljohnsonjr@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