Re: search_path and SET ROLE

Поиск
Список
Период
Сортировка
От Isaac Morland
Тема Re: search_path and SET ROLE
Дата
Msg-id CAMsGm5e8pJ0QgBdKr=bHzZNwugwd+rG8=3CzDzQZLyq+0W5APQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: search_path and SET ROLE  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: search_path and SET ROLE
Список pgsql-general
On Wed, 22 May 2024 at 13:48, Ron Johnson <ronljohnsonjr@gmail.com> wrote:

As a superuser administrator, I need to be able to see ALL tables in ALL schemas when running "\dt", not just the ones in "$user" and public.  And I need it to act consistently across all the systems.

\dt *.*

But I am skeptical how often you really want this in a real database with more than a few tables. Surely \dn+ followed by \dt [schemaname].* for a few strategically chosen [schemaname] would be more useful?

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: search_path wildcard?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Finding "most recent" using daterange