System Catalogs / System catalogs
pg_publication
Read the PG 18 manualThe catalog pg_publication contains all publications created in the database.
Reading PG 18current·documented in 11 of 24 versions, 10 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 10
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 10
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
pubname | nameNOT NULL | Name of the publication |
pubowner | oidNOT NULL | Owner of the publication pg_authid.oid |
puballtables | boolNOT NULL | If true, this publication automatically includes all tables in the database, including any that will be created in the future. |
pubinsert | boolNOT NULL | If true, INSERT operations are replicated for tables in the publication. |
pubupdate | boolNOT NULL | If true, UPDATE operations are replicated for tables in the publication. |
pubdelete | boolNOT NULL | If true, DELETE operations are replicated for tables in the publication. |
pubtruncate | boolNOT NULL | If true, TRUNCATE operations are replicated for tables in the publication. |
pubviaroot | boolNOT 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 | charNOT 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. |
Column history across versions
Version history 8
Definition snapshot: english-manuals:c4600f65a9d66d06ba0da83aac9… · English manual source