PostgreSQL : Documentation: 17: 51.41. pg_publication

51.41. `pg_publication_namespace`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.41. `pg_publication_namespace` #

The catalog pg_publication_namespace contains the mapping between schemas and publications in the database. This is a many-to-many mapping.

Table 51.41. pg_publication_namespace Columns

Column Type Description
`oid` `oid` Row identifier
`pnpubid` `oid` (references `pg_publication`.`oid`) Reference to publication
`pnnspid` `oid` (references `pg_namespace`.`oid`) Reference to schema

Column Type

Description

oid oid

Row identifier

pnpubid oid (references pg_publication.oid)

Reference to publication

pnnspid oid (references pg_namespace.oid)

Reference to schema

Prev	Up	Next
51.40. `pg_publication`	Home	51.42. `pg_publication_rel`

epub pdf