{"Entry":{"collection":"catalog","key":"pg_publication","name":"pg_publication","aliases":[],"metadata":{"changed_in":["11","12","13","18","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":["pubtruncate"],"attributes":[],"description_changed":false,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"changed","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":true,"descriptions":[],"from":"11","listing":[],"order":false,"removed":[],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":["pubviaroot"],"attributes":[],"description_changed":false,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"changed","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":["pubgencols"],"attributes":[],"description_changed":false,"descriptions":[],"from":"17","listing":[],"order":false,"removed":[],"status":"changed","to":"18","types":[],"unlisted":[]},{"added":["puballsequences"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":11,"content_hash":"dd5b43111fbabcf4e78d479b00f2ce9216322ab48279e3eda5fd8d13b8fed023","derived_content_hash":"788b809e51293bb9b57495c035888647af2706729f409fc71cbcba895c3c2b83","first_version":"10","imported_at":"2026-09-30T00:40:55.724982+08:00","kind":"catalog","last_version":"20","name":"pg_publication","position":58,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:44a90fb078c7abff30d5b844d2e233ebb96add968dc0b67a8957d84a4365f64e","summary":"The catalog pg_publication contains all publications created in the database.","summary_zh":"目录 pg_publication 包含数据库中创建的所有发布。关于发布的更多信息见第 29.1 节。"}},"Definition":{"Collection":"catalog","Key":"pg_publication","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_publication","SourceRevision":"catalog-bilingual-repair:44a90fb078c7abff30d5b844d2e233ebb96add968dc0b67a8957d84a4365f64e","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of the publication","description_zh":"发布名称","documented":true,"documented_name":"pubname","hidden":false,"name":"pubname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Owner of the publication","description_zh":"发布的拥有者","documented":true,"documented_name":"pubowner","hidden":false,"name":"pubowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"If true, this publication automatically includes all tables in the database, including any that will be created in the future.","description_zh":"如果为真，则该发布会自动包括数据库中的所有表，包括将来创建的表。","documented":true,"documented_name":"puballtables","hidden":false,"name":"puballtables","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"If true, INSERT operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 INSERT 操作。","documented":true,"documented_name":"pubinsert","hidden":false,"name":"pubinsert","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"If true, UPDATE operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 UPDATE 操作。","documented":true,"documented_name":"pubupdate","hidden":false,"name":"pubupdate","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"If true, DELETE operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 DELETE 操作。","documented":true,"documented_name":"pubdelete","hidden":false,"name":"pubdelete","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"If true, TRUNCATE operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 TRUNCATE 操作。","documented":true,"documented_name":"pubtruncate","hidden":false,"name":"pubtruncate","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"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.","description_zh":"如果为真，则叶子分区上的操作会使用该发布中提及的最顶层分区祖先的标识和模式进行复制，而不是使用叶子分区自己的标识和模式。","documented":true,"documented_name":"pubviaroot","hidden":false,"name":"pubviaroot","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"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.","description_zh":"控制在没有发布列列表时如何处理生成列复制：n = 不复制与该发布关联表中的生成列，s = 复制与该发布关联表中的存储式生成列。","documented":true,"documented_name":"pubgencols","hidden":false,"name":"pubgencols","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"}],"description":"The catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1.","description_zh":"目录 pg_publication 包含数据库中创建的所有发布。关于发布的更多信息见第 29.1 节。","description_zh_html":"\u003cp\u003e目录 pg_publication 包含数据库中创建的所有发布。关于发布的更多信息见第 29.1 节。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.42.4","file":"catalog-pg-publication.html","lang":"en","sha256":"120607e5ffd3273f36b03da82121bbdf90b03c38dc736ae31e7a3d483ce99934","slug":"18"},"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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-publication.html","sha256":"46f121c30b70a74acc7a0425571c08a9035f4c42a778478dbdbfa10f817844f5","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:c4600f65a9d66d06ba0da83aac92a304a5f2905b894612172a835a38ece9e9ba","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.42.4","file":"catalog-pg-publication.html","lang":"en","sha256":"120607e5ffd3273f36b03da82121bbdf90b03c38dc736ae31e7a3d483ce99934","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-publication.html","sha256":"46f121c30b70a74acc7a0425571c08a9035f4c42a778478dbdbfa10f817844f5","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:c4600f65a9d66d06ba0da83aac92a304a5f2905b894612172a835a38ece9e9ba","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","pubname","pubowner","puballtables","pubinsert","pubupdate","pubdelete","pubtruncate","pubviaroot","pubgencols"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_publication","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_publication","Summary":"The catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1.","BodyHTML":"\u003cp\u003eThe catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:44a90fb078c7abff30d5b844d2e233ebb96add968dc0b67a8957d84a4365f64e","ContentHash":"1165c411126d5fc51ddab9cc4734105ce6c27e5b2a48da5fb33f54db4a5ab08e","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of the publication","description_zh":"发布名称","documented":true,"documented_name":"pubname","hidden":false,"name":"pubname","not_null":true,"references":"","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Owner of the publication","description_zh":"发布的拥有者","documented":true,"documented_name":"pubowner","hidden":false,"name":"pubowner","not_null":true,"references":"pg_authid.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"If true, this publication automatically includes all tables in the database, including any that will be created in the future.","description_zh":"如果为真，则该发布会自动包括数据库中的所有表，包括将来创建的表。","documented":true,"documented_name":"puballtables","hidden":false,"name":"puballtables","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"If true, INSERT operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 INSERT 操作。","documented":true,"documented_name":"pubinsert","hidden":false,"name":"pubinsert","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":6,"description":"If true, UPDATE operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 UPDATE 操作。","documented":true,"documented_name":"pubupdate","hidden":false,"name":"pubupdate","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":7,"description":"If true, DELETE operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 DELETE 操作。","documented":true,"documented_name":"pubdelete","hidden":false,"name":"pubdelete","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"If true, TRUNCATE operations are replicated for tables in the publication.","description_zh":"如果为真，则会为发布中的表复制 TRUNCATE 操作。","documented":true,"documented_name":"pubtruncate","hidden":false,"name":"pubtruncate","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"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.","description_zh":"如果为真，则叶子分区上的操作会使用该发布中提及的最顶层分区祖先的标识和模式进行复制，而不是使用叶子分区自己的标识和模式。","documented":true,"documented_name":"pubviaroot","hidden":false,"name":"pubviaroot","not_null":true,"references":"","type":"bool","type_modifier":-1,"type_oid":16,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"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.","description_zh":"控制在没有发布列列表时如何处理生成列复制：n = 不复制与该发布关联表中的生成列，s = 复制与该发布关联表中的存储式生成列。","documented":true,"documented_name":"pubgencols","hidden":false,"name":"pubgencols","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"}],"description":"The catalog pg_publication contains all publications created in the database. For more on publications see Section 29.1."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}