↑↓ 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 10 has reached end of support. 2022-11-10. See the current manual.

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

Table 51.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.