{"Entry":{"collection":"catalog","key":"pg_publication_tables","name":"pg_publication_tables","aliases":[],"metadata":{"changed_in":["15"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":["attnames","rowfilter"],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"changed","to":"15","types":[],"unlisted":[]}],"column_count":5,"content_hash":"3dfdcb86d3d45ab9c4a26ce7535b69546d5a9edd52915186816524406e6fe9c9","derived_content_hash":"551e2044977df9e4eefc93c5fd1d79a23a0c12387566d41bd518c1fb556a45c2","first_version":"10","imported_at":"2026-09-30T00:40:55.736915+08:00","kind":"view","last_version":"20","name":"pg_publication_tables","position":62,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:ca21005bed7481aac54eae56b22e6e3a93923bf2b55eb7bda54005420b63ba43","summary":"The view pg_publication_tables provides information about the mapping between publications and information of tables they contain.","summary_zh":"视图 pg_publication_tables 提供发布与其所包含表之间映射关系的信息。与底层目录 pg_publication_rel 不同，该视图会展开定义为 FOR ALL TABLES 和 FOR TABLES IN SCHEMA 的发布，因此对于这类发布，每个符合条件的表都会有一行。"}},"Definition":{"Collection":"catalog","Key":"pg_publication_tables","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_publication_tables","SourceRevision":"catalog-bilingual-repair:ca21005bed7481aac54eae56b22e6e3a93923bf2b55eb7bda54005420b63ba43","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of publication","description_zh":"发布名称","documented":true,"documented_name":"pubname","hidden":false,"name":"pubname","not_null":false,"references":"pg_publication.pubname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of schema containing table","description_zh":"包含表的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of table","description_zh":"表的名称","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Names of table columns included in the publication. This contains all the columns of the table when the user didn't specify the column list for the table.","description_zh":"发布中包含的表列名称。当用户未为该表指定列列表时，这里包含该表的全部列。","documented":true,"documented_name":"attnames","hidden":false,"name":"attnames","not_null":false,"references":"pg_attribute.attname","type":"name[]","type_modifier":-1,"type_oid":1003,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Expression for the table's publication qualifying condition","description_zh":"该表的发布限定条件表达式","documented":true,"documented_name":"rowfilter","hidden":false,"name":"rowfilter","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalog pg_publication_rel, this view expands publications defined as FOR ALL TABLES and FOR TABLES IN SCHEMA, so for such publications there will be a row for each eligible table.","description_zh":"视图 pg_publication_tables 提供发布与其所包含表之间映射关系的信息。与底层目录 pg_publication_rel 不同，该视图会展开定义为 FOR ALL TABLES 和 FOR TABLES IN SCHEMA 的发布，因此对于这类发布，每个符合条件的表都会有一行。","description_zh_html":"\u003cp\u003e视图 pg_publication_tables 提供发布与其所包含表之间映射关系的信息。与底层目录 pg_publication_rel 不同，该视图会展开定义为 FOR ALL TABLES 和 FOR TABLES IN SCHEMA 的发布，因此对于这类发布，每个符合条件的表都会有一行。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.22.4","file":"view-pg-publication-tables.html","lang":"en","sha256":"c78fa7b6e9e2935c443cffbd15894a6ee12f88a060762ce69750349254b6f1f7","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pubname","schemaname","tablename","attnames","rowfilter"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-publication-tables.html","sha256":"c80dd0c987e6f256a4a3e843c4f89fab82d85be1005d4e4268ca5a52a6f4dc60","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:096c56f390ceaaafab926f764a06a44486dd1fa74ea23e2872c34513b17102d4","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.22.4","file":"view-pg-publication-tables.html","lang":"en","sha256":"c78fa7b6e9e2935c443cffbd15894a6ee12f88a060762ce69750349254b6f1f7","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-publication-tables.html","sha256":"c80dd0c987e6f256a4a3e843c4f89fab82d85be1005d4e4268ca5a52a6f4dc60","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:096c56f390ceaaafab926f764a06a44486dd1fa74ea23e2872c34513b17102d4","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["pubname","schemaname","tablename","attnames","rowfilter"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_publication_tables","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_publication_tables","Summary":"The view pg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalog pg_publication_rel, this view expands publications defined as FOR ALL TABLES and FOR TABLES IN SCHEMA, so for such publications there will be a row for each eligible table.","BodyHTML":"\u003cp\u003eThe view pg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalog pg_publication_rel, this view expands publications defined as FOR ALL TABLES and FOR TABLES IN SCHEMA, so for such publications there will be a row for each eligible table.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:ca21005bed7481aac54eae56b22e6e3a93923bf2b55eb7bda54005420b63ba43","ContentHash":"2d0c19f6d2171767f5c46d34498628324c8c96641175a9bb35b97f0b80160ecc","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of publication","description_zh":"发布名称","documented":true,"documented_name":"pubname","hidden":false,"name":"pubname","not_null":false,"references":"pg_publication.pubname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of schema containing table","description_zh":"包含表的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of table","description_zh":"表的名称","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Names of table columns included in the publication. This contains all the columns of the table when the user didn't specify the column list for the table.","description_zh":"发布中包含的表列名称。当用户未为该表指定列列表时，这里包含该表的全部列。","documented":true,"documented_name":"attnames","hidden":false,"name":"attnames","not_null":false,"references":"pg_attribute.attname","type":"name[]","type_modifier":-1,"type_oid":1003,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":5,"description":"Expression for the table's publication qualifying condition","description_zh":"该表的发布限定条件表达式","documented":true,"documented_name":"rowfilter","hidden":false,"name":"rowfilter","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_publication_tables provides information about the mapping between publications and information of tables they contain. Unlike the underlying catalog pg_publication_rel, this view expands publications defined as FOR ALL TABLES and FOR TABLES IN SCHEMA, so for such publications there will be a row for each eligible table."}},"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}