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.
Note
To check detailed information, you are advised to use the PG_PUBLICATION_TABLES view.
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.
postgres=# SELECT * FROM pg_publication_rel;
prpubid | prrelid
---------+---------
16797 | 16757
16797 | 16776
(2 rows)