Re: Request for new column in pg_namespace

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

ne 15. 12. 2024 v 17:59 odesílatel Ron Johnson <ronljohnsonjr@xxxxxxxxx> napsal:

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;

oid of all system objects is less then 0x4000

Regards

Pavel

 

--

Death to <Redacted>, and butter sauce.

Don't boil me, I'm still alive.

<Redacted> lobster!