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 53.18 for a more user-friendly view of this information.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, prpubid, prrelid, prqual, prattrs
- runtime verified
- false
- source
- english-manual
Definition PG 18
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 53.18 for a more user-friendly view of this information.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| prpubid | oid | Not null | Reference to publication |
| prrelid | oid | Not null | Reference to relation |
| prqual | pg_node_tree | Nullable | Expression tree (in nodeToString() representation) for the relation's publication qualifying condition. Null if there is no publication qualifying condition. |
| prattrs | int2vector | Nullable | 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. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:92d0d0bcbb1e2f539ff7c27eca6d5aa323ba671b42373cb15463ba76ea9bf952
Text language: en · catalog-bilingual-repair:92d0d0bcbb1e2f539ff7c27eca6d5aa323ba671b42373cb15463ba76ea9bf952