SYSTEM CATALOGS / SYSTEM CATALOGS
pg_publication_rel
Read PG 18 manual ↗The catalog pg_publication_rel contains the mapping between relations and publications in the database.
- Kind
- System catalogs
- Columns in this snapshot
- 5
- Definition source
- English manual
Columns 5
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
prpubid | oid | Reference to publication pg_publication.oid |
prrelid | oid | Reference to relation pg_class.oid |
prqual | pg_node_tree | Expression tree (in nodeToString() representation) for the relation's publication qualifying condition. Null if there is no publication qualifying condition. |
prattrs | int2vector | This is an array of values that indicates which table columns are part of the publication. For example, a value of 1 3 would mean that the first and the third table columns are published. A null value indicates that all columns are published. pg_attribute.attnum |
Column history across versions
Version history 9
- PG 18 → 19changed
- PG 17 → 18changed
- PG 16 → 17changed
- PG 14 → 15changed
- PG 13 → 14changed
- PG 12 → 13changed
- PG 11 → 12changed
- PG 10 → 11changed
- PG 9.6 → 10added
Definition snapshot: english-manuals:9181530669c2a0ae981cd1d6553… · English manual source