{"Entry":{"collection":"catalog","key":"pg_publication_rel","name":"pg_publication_rel","aliases":[],"metadata":{"changed_in":["12","15","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"10","listing":[],"order":false,"removed":[],"status":"reworded","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":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":["oid"],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]},{"added":["prqual","prattrs"],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"changed","to":"15","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"16","listing":[],"order":false,"removed":[],"status":"reworded","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"17","listing":[],"order":false,"removed":[],"status":"reworded","to":"18","types":[],"unlisted":[]},{"added":["prexcept"],"attributes":[],"description_changed":true,"descriptions":[{"from":"Reference to relation","name":"prrelid","to":"Reference to table"}],"from":"18","listing":[],"order":false,"removed":[],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":6,"content_hash":"b1d08feeaabd2a8b00dd555ffc9dbaa1538b1fc820c32408e3aa354e1ce0ae50","derived_content_hash":"71e6fd31175fb2c22f6635af62dacfdfd6edc138bf77b068c26643b3185b5b65","first_version":"10","imported_at":"2026-09-30T00:40:55.731554+08:00","kind":"catalog","last_version":"20","name":"pg_publication_rel","position":60,"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:92d0d0bcbb1e2f539ff7c27eca6d5aa323ba671b42373cb15463ba76ea9bf952","summary":"The catalog pg_publication_rel contains the mapping between relations and publications in the database.","summary_zh":"目录 pg_publication_rel 包含数据库中关系与发布之间的映射。这是一种多对多映射。关于这些信息更方便用户查看的视图，参见第 53.20 节。"}},"Definition":{"Collection":"catalog","Key":"pg_publication_rel","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_publication_rel","SourceRevision":"catalog-bilingual-repair:92d0d0bcbb1e2f539ff7c27eca6d5aa323ba671b42373cb15463ba76ea9bf952","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":"Reference to publication","description_zh":"对发布的引用","documented":true,"documented_name":"prpubid","hidden":false,"name":"prpubid","not_null":true,"references":"pg_publication.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Reference to relation","description_zh":"对关系的引用","documented":true,"documented_name":"prrelid","hidden":false,"name":"prrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Expression tree (in nodeToString() representation) for the relation's publication qualifying condition. Null if there is no publication qualifying condition.","description_zh":"关系的发布限定条件的表达式树（采用 nodeToString() 表示法）。如果没有发布限定条件，则为 NULL。","documented":true,"documented_name":"prqual","hidden":false,"name":"prqual","not_null":false,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"This is an array of values that indicates which table columns are part of the publication. For example, a value of 1 3 would mean that the first and the third table columns are published. A null value indicates that all columns are published.","description_zh":"这是一个值数组，指示哪些表列是发布的。例如，值为 1 3 表示第一和第三列被发布。空值表示所有列都被发布。","documented":true,"documented_name":"prattrs","hidden":false,"name":"prattrs","not_null":false,"references":"pg_attribute.attnum","type":"int2vector","type_modifier":-1,"type_oid":22,"zh_from":"same-version-manual"}],"description":"The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 53.18 for a more user-friendly view of this information.","description_zh":"目录 pg_publication_rel 包含数据库中关系与发布之间的映射。这是一种多对多映射。关于这些信息更方便用户查看的视图，参见第 53.18 节。","description_zh_html":"\u003cp\u003e目录 pg_publication_rel 包含数据库中关系与发布之间的映射。这是一种多对多映射。关于这些信息更方便用户查看的视图，参见第 53.18 节。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.44.4","file":"catalog-pg-publication-rel.html","lang":"en","sha256":"2b54908a3619c2e3f44b17b6b0184e13379c9c6880aedfaae0fe5fba5a971ebd","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","prpubid","prrelid","prqual","prattrs"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-publication-rel.html","sha256":"f3394acaab381e6dad44c4c484e4354f7e8c57dd130c5baec811b365e9553766","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ebd5ee0af606824f04d3a3fd2b094bc6a1b2fa26614c88baefb173847a62bcc6","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.44.4","file":"catalog-pg-publication-rel.html","lang":"en","sha256":"2b54908a3619c2e3f44b17b6b0184e13379c9c6880aedfaae0fe5fba5a971ebd","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-publication-rel.html","sha256":"f3394acaab381e6dad44c4c484e4354f7e8c57dd130c5baec811b365e9553766","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:ebd5ee0af606824f04d3a3fd2b094bc6a1b2fa26614c88baefb173847a62bcc6","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","prpubid","prrelid","prqual","prattrs"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_publication_rel","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_publication_rel","Summary":"The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 53.18 for a more user-friendly view of this information.","BodyHTML":"\u003cp\u003eThe catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 53.18 for a more user-friendly view of this information.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:92d0d0bcbb1e2f539ff7c27eca6d5aa323ba671b42373cb15463ba76ea9bf952","ContentHash":"27fbf9d1d104cc9eb2c136f42990c42a57f1b1c8811ec48ba6d5a77244329c04","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":"Reference to publication","description_zh":"对发布的引用","documented":true,"documented_name":"prpubid","hidden":false,"name":"prpubid","not_null":true,"references":"pg_publication.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Reference to relation","description_zh":"对关系的引用","documented":true,"documented_name":"prrelid","hidden":false,"name":"prrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Expression tree (in nodeToString() representation) for the relation's publication qualifying condition. Null if there is no publication qualifying condition.","description_zh":"关系的发布限定条件的表达式树（采用 nodeToString() 表示法）。如果没有发布限定条件，则为 NULL。","documented":true,"documented_name":"prqual","hidden":false,"name":"prqual","not_null":false,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"This is an array of values that indicates which table columns are part of the publication. For example, a value of 1 3 would mean that the first and the third table columns are published. A null value indicates that all columns are published.","description_zh":"这是一个值数组，指示哪些表列是发布的。例如，值为 1 3 表示第一和第三列被发布。空值表示所有列都被发布。","documented":true,"documented_name":"prattrs","hidden":false,"name":"prattrs","not_null":false,"references":"pg_attribute.attnum","type":"int2vector","type_modifier":-1,"type_oid":22,"zh_from":"same-version-manual"}],"description":"The catalog pg_publication_rel contains the mapping between relations and publications in the database. This is a many-to-many mapping. See also Section 53.18 for a more user-friendly view of this information."}},"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}