MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sun, 15 Dec 2024 11:58:49 -0500
Message-ID: <CANzqJaCCF9kpfdbWbRR2xuqH_qaBgL+me13w2c-5S=_YATKh+Q@mail.gmail.com>
Subject: Request for new column in pg_namespace
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000004e28c062951fbbe"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCCF9kpfdbWbRR2xuqH_qaBgL%2Bme13w2c-5S%3D_YATKh%2BQ%40mail.gmail.com>
Precedence: bulk

--00000000000004e28c062951fbbe
Content-Type: text/plain; charset="UTF-8"

https://www.postgresql.org/docs/current/catalog-pg-namespace.html

Currently, when I want to query all "userland" tables, I write something
like:
select ...
from pg_class cl, pg_namespace nsp
where cl.relnamespace = nsp.oid
  and nsp.nspname not like 'pg_%
  and nsp.nspname != 'information_schema';

A new boolean column named "indissystem" that's true only for system
relations would make *many* maintenance queries cleaner, since they'd look
like:
select ...
from pg_class cl, pg_namespace nsp
where cl.relnamespace = nsp.oid
  and nsp.indissystem = false;

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div><a href=3D"https://www.postgresql.org/docs/current/ca=
talog-pg-namespace.html">https://www.postgresql.org/docs/current/catalog-pg=
-namespace.html</a></div><div><br></div><div>Currently, when I want to quer=
y all &quot;userland&quot; tables, I write something like:</div><div><font =
face=3D"monospace">select ...<br>from pg_class cl, pg_namespace nsp<br>wher=
e cl.relnamespace =3D nsp.oid<br>=C2=A0 and nsp.nspname not like &#39;pg_%<=
/font></div><div><font face=3D"monospace">=C2=A0 and=C2=A0</font><span styl=
e=3D"font-family:monospace">nsp.</span><span style=3D"font-family:monospace=
">nspname</span><span style=3D"font-family:monospace">=C2=A0!=3D</span><spa=
n style=3D"font-family:monospace">=C2=A0&#39;information_schema&#39;;</span=
></div><div><br></div><div>A new boolean column named &quot;indissystem&quo=
t; that&#39;s true only for system relations would make <i>many</i>=C2=A0ma=
intenance queries cleaner, since they&#39;d look like:</div><div><div><font=
 face=3D"monospace">select ...<br>from pg_class cl, pg_namespace nsp<br>whe=
re cl.relnamespace =3D nsp.oid<br>=C2=A0 and nsp.indissystem =3D false;</fo=
nt></div></div><div><br></div><span class=3D"gmail_signature_prefix">-- </s=
pan><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_=
signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<di=
v>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lob=
ster!</div></div></div></div></div></div>

--00000000000004e28c062951fbbe--