Re: Request for new column in pg_namespace

Hi

ne 15. 12. 2024 v 17:59 odesílatel Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
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!
>