pg_publication_namespace
A system table containing the relationship between schemas and publications
pg_publication_namespace
is a system catalog table containing the mapping between schemas and publications.
pg_publication_namespace
was added in PostgreSQL 15.
Definition by PostgreSQL version
pg_publication_namespace (PostgreSQL 16)
Table "pg_catalog.pg_publication_namespace" Column | Type | Collation | Nullable | Default ---------+------+-----------+----------+--------- oid | oid | | not null | pnpubid | oid | | not null | pnnspid | oid | | not null | Indexes: "pg_publication_namespace_oid_index" PRIMARY KEY, btree (oid) "pg_publication_namespace_pnnspid_pnpubid_index" UNIQUE CONSTRAINT, btree (pnnspid, pnpubid)
Documentation: pg_publication_namespace
pg_publication_namespace (PostgreSQL 15)
Table "pg_catalog.pg_publication_namespace" Column | Type | Collation | Nullable | Default ---------+------+-----------+----------+--------- oid | oid | | not null | pnpubid | oid | | not null | pnnspid | oid | | not null | Indexes: "pg_publication_namespace_oid_index" PRIMARY KEY, btree (oid) "pg_publication_namespace_pnnspid_pnpubid_index" UNIQUE CONSTRAINT, btree (pnnspid, pnpubid)
Documentation: pg_publication_namespace
Change history
- PostgreSQL 15
- added (commit 5a283246)
Examples
If creating a publication for a schema, an entry associating the schema with the publication will be created in pg_publication_namespace
:
postgres=# CREATE PUBLICATION foopub FOR ALL TABLES IN SCHEMA foo; CREATE PUBLICATION postgres=# SELECT * FROM pg_publication_namespace ; oid | pnpubid | pnnspid -------+---------+--------- 16430 | 16429 | 16414 (1 row)
References
- PostgreSQL documentation: pg_publication_namespace