Postgresql 中文操作指南
53.40. pg_publication #
目录 pg_publication 包含在数据库中创建的所有发布。有关发行版的详细信息,请参阅 Section 31.1。
The catalog pg_publication contains all publications created in the database. For more on publications see Section 31.1.
Table 53.40. pg_publication Columns
Table 53.40. pg_publication Columns
Column Type Description |
oid oid Row identifier |
pubname name Name of the publication |
pubowner oid (references pg_authid.oid) Owner of the publication |
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. |