pg_publication
The catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1.
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, pubname, pubowner, puballtables, pubinsert, pubupdate, pubdelete, pubtruncate, pubviaroot, pubgencols
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| pubname | name | Not null | Name of the publication |
| pubowner | oid | Not null | Owner of the publication |
| puballtables | bool | Not null | If true, this publication automatically includes all tables in the database, including any that will be created in the future. |
| pubinsert | bool | Not null | If true, INSERT operations are replicated for tables in the publication. |
| pubupdate | bool | Not null | If true, UPDATE operations are replicated for tables in the publication. |
| pubdelete | bool | Not null | If true, DELETE operations are replicated for tables in the publication. |
| pubtruncate | bool | Not null | If true, TRUNCATE operations are replicated for tables in the publication. |
| pubviaroot | bool | Not null | If true, operations on a leaf partition are replicated using the identity and schema of its topmost partitioned ancestor mentioned in the publication instead of its own. |
| pubgencols | char | Not null | Controls how to handle generated column replication when there is no publication column list: n = generated columns in the tables associated with the publication should not be replicated, s = stored generated columns in the tables associated with the publication should be replicated. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:44a90fb078c7abff30d5b844d2e233ebb96add968dc0b67a8957d84a4365f64e
Text language: en · catalog-bilingual-repair:44a90fb078c7abff30d5b844d2e233ebb96add968dc0b67a8957d84a4365f64e