Re: Request for new column in pg_namespace - Mailing list pgsql-general

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!