catalog-pg-publication.md 2.4 KB
Newer Older
K
KyleZhang 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
## 52.39. `pg_publication`

[]()

 The catalog `pg_publication` contains all publications created in the database. For more on publications see [Section 31.1](logical-replication-publication.html).

**Table 52.39. `pg_publication` Columns**

|                                                                                   Column Type<br/><br/> Description                                                                                   |
|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|                                                                                 `oid` `oid`<br/><br/> Row identifier                                                                                  |
|                                                                          `pubname` `name`<br/><br/> Name of the publication                                                                           |
|                                             `pubowner` `oid` (references [`pg_authid`](catalog-pg-authid.html).`oid`)<br/><br/> Owner of the publication                                              |
|                    `puballtables` `bool`<br/><br/> If true, this publication automatically includes all tables in the database, including any that will be created in the future.                     |
|                                       `pubinsert` `bool`<br/><br/> If true, [INSERT](sql-insert.html) operations are replicated for tables in the publication.                                        |
|                                       `pubupdate` `bool`<br/><br/> If true, [UPDATE](sql-update.html) operations are replicated for tables in the publication.                                        |
|                                       `pubdelete` `bool`<br/><br/> If true, [DELETE](sql-delete.html) operations are replicated for tables in the publication.                                        |
|                                    `pubtruncate` `bool`<br/><br/> If true, [TRUNCATE](sql-truncate.html) operations are replicated for tables in the publication.                                     |
|`pubviaroot` `bool`<br/><br/> 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.|