MIME-Version: 1.0
References: <CANzqJaBoAkdXMkPvdXqhkBduLqpTbU7BdjyZePcuWkFnKi1SDQ@mail.gmail.com>
 <4165841.1716397819@sss.pgh.pa.us> <CANzqJaDfSaB=EvGCABT8VA_2FwYM4MYUmQYT5e-bw-Tf_EH13Q@mail.gmail.com>
In-Reply-To: <CANzqJaDfSaB=EvGCABT8VA_2FwYM4MYUmQYT5e-bw-Tf_EH13Q@mail.gmail.com>
From: Isaac Morland <isaac.morland@gmail.com>
Date: Wed, 22 May 2024 14:01:54 -0400
Message-ID: <CAMsGm5e8pJ0QgBdKr=bHzZNwugwd+rG8=3CzDzQZLyq+0W5APQ@mail.gmail.com>
Subject: Re: search_path and SET ROLE
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008ff48506190ebb86"
Archived-At: <https://www.postgresql.org/message-id/CAMsGm5e8pJ0QgBdKr%3DbHzZNwugwd%2BrG8%3D3CzDzQZLyq%2B0W5APQ%40mail.gmail.com>
Precedence: bulk

--0000000000008ff48506190ebb86
Content-Type: text/plain; charset="UTF-8"

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?

--0000000000008ff48506190ebb86
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, 22 May 2024 at 13:48, Ron Johnson=
 &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>=
&gt; wrote:<br></div><div class=3D"gmail_quote"><div><br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1=
px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:=
1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><div>As a superuser admini=
strator, I need to be able to see ALL tables in ALL schemas when running &q=
uot;\dt&quot;, not just the ones in &quot;$user&quot; and public.=C2=A0 And=
 I need it to act consistently across all the systems.</div></div></div></b=
lockquote><div><br></div><div>\dt *.*</div><div><br></div><div>But I am ske=
ptical how often you really want this in a real database with more than a f=
ew tables. Surely \dn+ followed by \dt [schemaname].* for a few strategical=
ly chosen [schemaname] would be more useful?<br></div></div></div>

--0000000000008ff48506190ebb86--