↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10
Historical version. PostgreSQL 11 has reached end of support. 2023-11-09. See the current manual.

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

Table 52.41. pg_publication_rel Columns

NameTypeReferencesDescription
prpubidoidpg_publication.oidReference to publication
prrelidoidpg_class.oidReference to relation

Report a documentation issue

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