Home > mailing lists

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

From	Ron Johnson
Subject	Request for new column in pg_namespace
Date	December 15 22:58:49
Msg-id	CANzqJaCCF9kpfdbWbRR2xuqH_qaBgL+me13w2c-5S=_YATKh+Q@mail.gmail.com Whole thread Raw
Responses	Re: Request for new column in pg_namespace
List	pgsql-general

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!

From: Tom Lane
Date: 15 December, 03:37:30
Subject: Re: Allowed to return possibly TOASTed datums?

From: Pavel Stehule
Date: 15 December, 23:15:57
Subject: Re: Request for new column in pg_namespace