51.40. pg_publication_rel — PostgreSQL 13

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10

Historical version. PostgreSQL 13 has reached end of support. 2025-11-13. See the current manual.

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

51.40. `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 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`

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.