Updated on 2024-09-02 GMT+08:00

PG_PUBLICATION_REL

PG_PUBLICATION_REL records the mapping between publications and tables in the current database, which is a many-to-many mapping. This system catalog is supported only by clusters of version 8.2.0.100 or later.

To check detailed information, you are advised to use the PG_PUBLICATION_TABLES view.

Table 1 PG_PUBLICATION_REL columns

Name

Type

Reference

Description

oid

oid

-

Row identifier (hidden attribute; displayed only when explicitly selected)

prpubid

oid

PG_PUBLICATION.oid

Publication OID in the mapping

prrelid

oid

PG_CLASS.oid

OID of the mapped table

Examples

View all mappings between publications and tables.

1
2
3
4
5
6
postgres=# SELECT * FROM pg_publication_rel;
 prpubid | prrelid 
---------+---------
   16797 |   16757
   16797 |   16776
(2 rows)