System Catalogs / System catalogs
pg_publication_rel
Read the PG 18 manualThe catalog pg_publication_rel contains the mapping between relations and publications in the database.
Reading PG 18current·documented in 11 of 24 versions, 10 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 5
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 5
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
prpubid | oidNOT NULL | Reference to publication pg_publication.oid |
prrelid | oidNOT NULL | 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
Definition snapshot: english-manuals:ebd5ee0af606824f04d3a3fd2b0… · English manual source