Hi ne 15. 12. 2024 v 17:59 odesÃlatel Ron Johnson <ronljohnso...@gmail.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! >
