51.40. pg_publication_rel

51.40. `pg_publication_rel`
Prev	Up	Chapter 51. System Catalogs	Home	Next

The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 51.78 for a more user-friendly view of this information.

Table 51.40. pg_publication_rel Columns

Column Type Description
`oid` `oid` Row identifier
`prpubid` `oid` (references `pg_publication` . `oid` ) Reference to publication
`prrelid` `oid` (references `pg_class` . `oid` ) Reference to relation

Column Type

Description

oid oid

Row identifier

prpubid oid (references pg_publication . oid )

Reference to publication

prrelid oid (references pg_class . oid )

Reference to relation

Prev	Up	Next
51.39. `pg_publication`	Home	51.41. `pg_range`