Re: PSQL - prevent describe listing tables that are already in listed schemas

On Wed, 8 Jul 2026 at 04:58, Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
>
> A rebase was needed.
>
> PSA v7.

One minor comment:
Can we add a comment here too, similar to how you have added for
describe publications:
@@ -3048,7 +3048,12 @@ describeOneTableDetails(const char *schemaname,
"FROM
pg_catalog.pg_publication p\n"
" JOIN
pg_catalog.pg_publication_rel pr ON p.oid = pr.prpubid\n"
" JOIN
pg_catalog.pg_class c ON c.oid = pr.prrelid\n"
- "WHERE
pr.prrelid = '%s'\n",
+ "WHERE
pr.prrelid = '%s'\n"
+ " AND NOT EXISTS (\n"
+ " SELECT 1\n"
+ " FROM
pg_catalog.pg_publication_namespace pn\n"
+ " WHERE
pn.pnpubid = p.oid\n"
+ " AND
pn.pnnspid = c.relnamespace)\n",
oid, oid, oid);

Regards,
Vignesh