PG_PUBLICATION_NAMESPACE¶
PG_PUBLICATION_NAMESPACE records the mapping between publications and schemas in the current database, which is a many-to-many mapping. This system catalog is supported only by clusters of version 8.2.0.100 or later.
Name | Type | Reference | Description |
|---|---|---|---|
oid | oid |
| Row identifier (hidden attribute; displayed only when explicitly selected) |
prpubid | oid | PG_PUBLICATION.oid | Publication OID in the mapping |
pnnspid | oid | PG_NAMESPACE.oid | Schema OID in the mapping |
Examples¶
View all mappings between publications and schemas.
SELECT * FROM pg_publication_namespace;
pnpubid | pnnspid
---------+---------
16797 | 16796
(1 row)