SYSTEM CATALOGS / SYSTEM CATALOGS
pg_publication
Read PG 18 manual ↗The catalog pg_publication contains all publications created in the database.
- Kind
- System catalogs
- Columns in this snapshot
- 10
- Definition source
- English manual
Columns 10
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
pubname | name | Name of the publication |
pubowner | oid | Owner of the publication pg_authid.oid |
puballtables | bool | If true, this publication automatically includes all tables in the database, including any that will be created in the future. |
pubinsert | bool | If true, INSERT operations are replicated for tables in the publication. |
pubupdate | bool | If true, UPDATE operations are replicated for tables in the publication. |
pubdelete | bool | If true, DELETE operations are replicated for tables in the publication. |
pubtruncate | bool | If true, TRUNCATE operations are replicated for tables in the publication. |
pubviaroot | bool | 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 | 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
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
oid | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubname | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubowner | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
puballtables | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubinsert | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubupdate | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubdelete | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubtruncate | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
pubviaroot | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● |
pubgencols | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
puballsequences | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 8
- PG 18 → 19changed
- PG 17 → 18changed
- PG 16 → 17changed
- PG 13 → 14changed
- PG 12 → 13changed
- PG 11 → 12changed
- PG 10 → 11changed
- PG 9.6 → 10added
Definition snapshot: english-manuals:1dc02d96955e057e5e3d6c4fe4f… · English manual source