Re: search_path and SET ROLE

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: search_path and SET ROLE
Date: 2024-05-22 18:01:54
Message-ID: CAMsGm5e8pJ0QgBdKr=bHzZNwugwd+rG8=3CzDzQZLyq+0W5APQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 22 May 2024 at 13:48, Ron Johnson <ronljohnsonjr(at)gmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2024-05-22 18:07:25 Re: Finding "most recent" using daterange
Previous Message Tom Lane 2024-05-22 17:58:50 Re: search_path wildcard?