{"Entry":{"collection":"catalog","key":"pg_partitioned_table","name":"pg_partitioned_table","aliases":[],"metadata":{"changed_in":["11"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":["partdefid"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Partitioning strategy; l = list partitioned table, r = range partitioned table","name":"partstrat","to":"Partitioning strategy; h = hash partitioned table, l = list partitioned table, r = range partitioned table"}],"from":"10","listing":[],"order":false,"removed":[],"status":"changed","to":"11","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"The OID of the pg_class entry for the default partition of this partitioned table, or zero if this partitioned table does not have a default partition.","name":"partdefid","to":"The OID of the pg_class entry for the default partition of this partitioned table, or zero if this partitioned table does not have a default partition"},{"from":"The number of columns in partition key","name":"partnatts","to":"The number of columns in the partition key"}],"from":"13","listing":[],"order":false,"removed":[],"status":"reworded","to":"14","types":[],"unlisted":[]}],"column_count":8,"content_hash":"95f701fc75d111529356e7e4f30a6d9f17db0fe55a604ff64062aca7dbcefa84","derived_content_hash":"5a9f51460eeefeea2423d0f257a80fc621ee97736558ada65419f0276e7ff0b3","first_version":"10","imported_at":"2026-09-30T00:40:55.667251+08:00","kind":"catalog","last_version":"20","name":"pg_partitioned_table","position":51,"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:cc8b7dfae24cd52701502505856a7fb808c8fbd55c8fbf09a663e6a188ec3c4e","summary":"The catalog pg_partitioned_table stores information about how tables are partitioned.","summary_zh":"目录 pg_partitioned_table 存放有关表如何被分区的信息。"}},"Definition":{"Collection":"catalog","Key":"pg_partitioned_table","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_partitioned_table","SourceRevision":"catalog-bilingual-repair:cc8b7dfae24cd52701502505856a7fb808c8fbd55c8fbf09a663e6a188ec3c4e","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the pg_class entry for this partitioned table","description_zh":"这个分区表的 pg_class 项的 OID","documented":true,"documented_name":"partrelid","hidden":false,"name":"partrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Partitioning strategy; h = hash partitioned table, l = list partitioned table, r = range partitioned table","description_zh":"分区策略；h = hash 分区表，l = 列表分区表，r = 范围分区表","documented":true,"documented_name":"partstrat","hidden":false,"name":"partstrat","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The number of columns in the partition key","description_zh":"分区键中的列数","documented":true,"documented_name":"partnatts","hidden":false,"name":"partnatts","not_null":true,"references":"","type":"int2","type_modifier":-1,"type_oid":21,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"The OID of the pg_class entry for the default partition of this partitioned table, or zero if this partitioned table does not have a default partition","description_zh":"这个分区表的默认分区的 pg_class 项的 OID，如果这个分区表没有默认分区则为零。","documented":true,"documented_name":"partdefid","hidden":false,"name":"partdefid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"This is an array of partnatts values that indicate which table columns are part of the partition key. For example, a value of 1 3 would mean that the first and the third table columns make up the partition key. A zero in this array indicates that the corresponding partition key column is an expression, rather than a simple column reference.","description_zh":"这是一个包含 partnatts 个值的数组，它指示哪些表列是分区键的组成部分。例如，值 1 3 表示第一个和第三个表列组成了分区键。这个数组中的零表示对应的分区键列是一个表达式而不是简单的列引用。","documented":true,"documented_name":"partattrs","hidden":false,"name":"partattrs","not_null":true,"references":"pg_attribute.attnum","type":"int2vector","type_modifier":-1,"type_oid":22,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":6,"description":"For each column in the partition key, this contains the OID of the operator class to use. See pg_opclass for details.","description_zh":"对于分区键中的每一个列，此字段包含要使用的操作符类的 OID。详见 pg_opclass。","documented":true,"documented_name":"partclass","hidden":false,"name":"partclass","not_null":true,"references":"pg_opclass.oid","type":"oidvector","type_modifier":-1,"type_oid":30,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":7,"description":"For each column in the partition key, this contains the OID of the collation to use for partitioning, or zero if the column is not of a collatable data type.","description_zh":"对于分区键中的每一个列，此字段包含要用于分区的排序规则的 OID，如果该列的数据类型不支持排序规则则为零。","documented":true,"documented_name":"partcollation","hidden":false,"name":"partcollation","not_null":true,"references":"pg_collation.oid","type":"oidvector","type_modifier":-1,"type_oid":30,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Expression trees (in nodeToString() representation) for partition key columns that are not simple column references. This is a list with one element for each zero entry in partattrs. Null if all partition key columns are simple references.","description_zh":"非简单列引用的分区键列的表达式树（以 nodeToString() 的表达方式）。这是一个列表，partattrs 中每一个零项都有一个元素。如果所有分区键列都是简单列引用，则此字段为 NULL。","documented":true,"documented_name":"partexprs","hidden":false,"name":"partexprs","not_null":false,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194,"zh_from":"same-version-manual"}],"description":"The catalog pg_partitioned_table stores information about how tables are partitioned.","description_zh":"目录 pg_partitioned_table 存放有关表如何被分区的信息。","description_zh_html":"\u003cp\u003e目录 pg_partitioned_table 存放有关表如何被分区的信息。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.39.4","file":"catalog-pg-partitioned-table.html","lang":"en","sha256":"1f1058fb4fb9566b3e21b5ee32fe9ca2eba728008dde2904df7e41719a49c687","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["partrelid","partstrat","partnatts","partdefid","partattrs","partclass","partcollation","partexprs"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-partitioned-table.html","sha256":"b0e0bf583bdf037a7182d1aa723c0332bbc0cd0ebd7fd851473c533e4d82484a","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:c21a4a78f2a795b9eee1cf075fc154163093e0adf141f00e1b4d6550d3934085","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.39.4","file":"catalog-pg-partitioned-table.html","lang":"en","sha256":"1f1058fb4fb9566b3e21b5ee32fe9ca2eba728008dde2904df7e41719a49c687","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-partitioned-table.html","sha256":"b0e0bf583bdf037a7182d1aa723c0332bbc0cd0ebd7fd851473c533e4d82484a","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:c21a4a78f2a795b9eee1cf075fc154163093e0adf141f00e1b4d6550d3934085","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["partrelid","partstrat","partnatts","partdefid","partattrs","partclass","partcollation","partexprs"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_partitioned_table","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_partitioned_table","Summary":"The catalog pg_partitioned_table stores information about how tables are partitioned.","BodyHTML":"\u003cp\u003eThe catalog pg_partitioned_table stores information about how tables are partitioned.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:cc8b7dfae24cd52701502505856a7fb808c8fbd55c8fbf09a663e6a188ec3c4e","ContentHash":"9eafc5014439d6c824fdb4143cce274aa6e0603b019302344f5d36d2a81f451d","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the pg_class entry for this partitioned table","description_zh":"这个分区表的 pg_class 项的 OID","documented":true,"documented_name":"partrelid","hidden":false,"name":"partrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Partitioning strategy; h = hash partitioned table, l = list partitioned table, r = range partitioned table","description_zh":"分区策略；h = hash 分区表，l = 列表分区表，r = 范围分区表","documented":true,"documented_name":"partstrat","hidden":false,"name":"partstrat","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The number of columns in the partition key","description_zh":"分区键中的列数","documented":true,"documented_name":"partnatts","hidden":false,"name":"partnatts","not_null":true,"references":"","type":"int2","type_modifier":-1,"type_oid":21,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"The OID of the pg_class entry for the default partition of this partitioned table, or zero if this partitioned table does not have a default partition","description_zh":"这个分区表的默认分区的 pg_class 项的 OID，如果这个分区表没有默认分区则为零。","documented":true,"documented_name":"partdefid","hidden":false,"name":"partdefid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":5,"description":"This is an array of partnatts values that indicate which table columns are part of the partition key. For example, a value of 1 3 would mean that the first and the third table columns make up the partition key. A zero in this array indicates that the corresponding partition key column is an expression, rather than a simple column reference.","description_zh":"这是一个包含 partnatts 个值的数组，它指示哪些表列是分区键的组成部分。例如，值 1 3 表示第一个和第三个表列组成了分区键。这个数组中的零表示对应的分区键列是一个表达式而不是简单的列引用。","documented":true,"documented_name":"partattrs","hidden":false,"name":"partattrs","not_null":true,"references":"pg_attribute.attnum","type":"int2vector","type_modifier":-1,"type_oid":22,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":6,"description":"For each column in the partition key, this contains the OID of the operator class to use. See pg_opclass for details.","description_zh":"对于分区键中的每一个列，此字段包含要使用的操作符类的 OID。详见 pg_opclass。","documented":true,"documented_name":"partclass","hidden":false,"name":"partclass","not_null":true,"references":"pg_opclass.oid","type":"oidvector","type_modifier":-1,"type_oid":30,"zh_from":"same-version-manual"},{"array_dimensions":1,"attnum":7,"description":"For each column in the partition key, this contains the OID of the collation to use for partitioning, or zero if the column is not of a collatable data type.","description_zh":"对于分区键中的每一个列，此字段包含要用于分区的排序规则的 OID，如果该列的数据类型不支持排序规则则为零。","documented":true,"documented_name":"partcollation","hidden":false,"name":"partcollation","not_null":true,"references":"pg_collation.oid","type":"oidvector","type_modifier":-1,"type_oid":30,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Expression trees (in nodeToString() representation) for partition key columns that are not simple column references. This is a list with one element for each zero entry in partattrs. Null if all partition key columns are simple references.","description_zh":"非简单列引用的分区键列的表达式树（以 nodeToString() 的表达方式）。这是一个列表，partattrs 中每一个零项都有一个元素。如果所有分区键列都是简单列引用，则此字段为 NULL。","documented":true,"documented_name":"partexprs","hidden":false,"name":"partexprs","not_null":false,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194,"zh_from":"same-version-manual"}],"description":"The catalog pg_partitioned_table stores information about how tables are partitioned."}},"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}