Postgres Pro Enterprise : Documentation: 16: 54.42. pg_publication

54.42. `pg_publication_namespace`
Prev	Up	Chapter 54. System Catalogs	Home	Next

54.42. `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 54.42. 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
54.41. `pg_publication`	Home	54.43. `pg_publication_rel`

epub pdf