MIME-Version: 1.0
References: <CANzqJaBoAkdXMkPvdXqhkBduLqpTbU7BdjyZePcuWkFnKi1SDQ@mail.gmail.com>
 <4165841.1716397819@sss.pgh.pa.us> <CANzqJaDfSaB=EvGCABT8VA_2FwYM4MYUmQYT5e-bw-Tf_EH13Q@mail.gmail.com>
 <CAMsGm5e8pJ0QgBdKr=bHzZNwugwd+rG8=3CzDzQZLyq+0W5APQ@mail.gmail.com>
In-Reply-To: <CAMsGm5e8pJ0QgBdKr=bHzZNwugwd+rG8=3CzDzQZLyq+0W5APQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 22 May 2024 15:38:30 -0400
Message-ID: <CANzqJaCKvZ-8VgqNTpJK2Tm9iXp+rMbs2RV+CTQSETUTua8cdA@mail.gmail.com>
Subject: Re: search_path and SET ROLE
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000eaccbb06191014d7"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCKvZ-8VgqNTpJK2Tm9iXp%2BrMbs2RV%2BCTQSETUTua8cdA%40mail.gmail.com>
Precedence: bulk

--000000000000eaccbb06191014d7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, May 22, 2024 at 2:02=E2=80=AFPM Isaac Morland <isaac.morland@gmail.=
com>
wrote:

> 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.  An=
d I
>> need it to act consistently across all the systems.
>>
>
> \dt *.*
>

Also shows information_schema, pg_catalog, and pg_toast.  I can adjust to
that, though.


> 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?
>

More than you'd think.  I'm always looking up the definition of this table
or that table (mostly for indices and keys), and I never remember which
schema they're in.

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, May 22, 2024 at 2:02=E2=80=AFPM I=
saac Morland &lt;<a href=3D"mailto:isaac.morland@gmail.com">isaac.morland@g=
mail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed=
, 22 May 2024 at 13:48, Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gma=
il.com" target=3D"_blank">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:1px solid rgb(204,204,204);pa=
dding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quote"><div>As a super=
user administrator, I need to be able to see ALL tables in ALL schemas when=
 running &quot;\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></di=
v></div></blockquote><div><br></div><div>\dt *.*</div></div></div></blockqu=
ote><div><br></div><div>Also shows information_schema, pg_catalog, and pg_t=
oast.=C2=A0 I can adjust to that, though.</div><div>=C2=A0</div><blockquote=
 class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px so=
lid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail=
_quote"><div></div><div>But I am skeptical how often you really want this i=
n a real database with more than a few tables. Surely \dn+ followed by \dt =
[schemaname].* for a few strategically chosen [schemaname] would be more us=
eful?<br></div></div></div></blockquote><div><br></div><div>More than you&#=
39;d think.=C2=A0 I&#39;m always looking up the definition of this table or=
 that table (mostly for indices and keys), and I never remember which schem=
a they&#39;re in.</div><div><br></div></div></div>

--000000000000eaccbb06191014d7--