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> <CANzqJaCKvZ-8VgqNTpJK2Tm9iXp+rMbs2RV+CTQSETUTua8cdA@mail.gmail.com>
In-Reply-To: <CANzqJaCKvZ-8VgqNTpJK2Tm9iXp+rMbs2RV+CTQSETUTua8cdA@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Wed, 22 May 2024 21:40:52 +0200
Message-ID: <CAFj8pRDnocKb-HV=t1Dk1VQa0y2Kh7XBwLz3DjCiMP+_y-UTQw@mail.gmail.com>
Subject: Re: search_path and SET ROLE
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ea60ce0619101e14"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRDnocKb-HV%3Dt1Dk1VQa0y2Kh7XBwLz3DjCiMP%2B_y-UTQw%40mail.gmail.com>
Precedence: bulk

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

st 22. 5. 2024 v 21:38 odes=C3=ADlatel Ron Johnson <ronljohnsonjr@gmail.com=
>
napsal:

> On Wed, May 22, 2024 at 2:02=E2=80=AFPM Isaac Morland <isaac.morland@gmai=
l.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.  A=
nd 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 wit=
h
>> 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 tabl=
e
> or that table (mostly for indices and keys), and I never remember which
> schema they're in.
>

\d *.pg_class

Unfortunately  in this case, tab complete doesn't work

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">st 22. 5. 2024 v=C2=A021:38 odes=C3=
=ADlatel Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">ronljoh=
nsonjr@gmail.com</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, May 22, 2024 at =
2:02=E2=80=AFPM Isaac Morland &lt;<a href=3D"mailto:isaac.morland@gmail.com=
" target=3D"_blank">isaac.morland@gmail.com</a>&gt; wrote:<br></div><div cl=
ass=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 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@gmail.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);padding-left:1ex"><div dir=3D"ltr"><div cl=
ass=3D"gmail_quote"><div>As a superuser administrator, I need to be able to=
 see ALL tables in ALL schemas when running &quot;\dt&quot;, not just the o=
nes in &quot;$user&quot; and public.=C2=A0 And I need it to act consistentl=
y across all the systems.</div></div></div></blockquote><div><br></div><div=
>\dt *.*</div></div></div></blockquote><div><br></div><div>Also shows infor=
mation_schema, pg_catalog, and pg_toast.=C2=A0 I can adjust to that, though=
.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><=
div dir=3D"ltr"><div class=3D"gmail_quote"><div></div><div>But I am skeptic=
al how often you really want this in a real database with more than a few t=
ables. Surely \dn+ followed by \dt [schemaname].* for a few strategically c=
hosen [schemaname] would be more useful?<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 schema they&#39;re in.</div></div></div></blo=
ckquote><div><br></div><div>\d *.pg_class</div><div><br></div><div>Unfortun=
ately=C2=A0 in this case, tab complete doesn&#39;t work<br></div></div></di=
v>

--000000000000ea60ce0619101e14--