48.46. pg_publication

48.46. `pg_publication_rel`
Prev	Up	Chapter 48. System Catalogs	Home	Next

48.46. `pg_publication_rel`

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 48.84 for a more user-friendly view of this information.

Table 48.46. 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
48.45. `pg_publication`	Home	48.47. `pg_range`

48.46. pg_publication_rel

48.46. `pg_publication_rel`