Re: Request for new column in pg_namespace
От | Pavel Stehule |
---|---|
Тема | Re: Request for new column in pg_namespace |
Дата | |
Msg-id | CAFj8pRDxMpQv4P3Bi-zEQ+OQ2dsVCZ+g-vbpU-F3qvozZKjUzA@mail.gmail.com обсуждение исходный текст |
Ответ на | Request for new column in pg_namespace (Ron Johnson <ronljohnsonjr@gmail.com>) |
Ответы |
Re: Request for new column in pg_namespace
|
Список | pgsql-general |
Hi
ne 15. 12. 2024 v 17:59 odesílatel Ron Johnson <ronljohnsonjr@gmail.com> napsal:
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!
В списке pgsql-general по дате отправления: