{"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":"d3d2392ea918af9865b3205f8f7240fcb850eea1e52ffc00ea68763b3d6dd893","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":"english-manuals:c21a4a78f2a795b9eee1cf075fc154163093e0adf141f00e1b4d6550d3934085","summary":"The catalog pg_partitioned_table stores information about how tables are partitioned.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_partitioned_table","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_partitioned_table","SourceRevision":"english-manuals:c21a4a78f2a795b9eee1cf075fc154163093e0adf141f00e1b4d6550d3934085","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the pg_class entry for this partitioned table","description_zh":"","documented":true,"documented_name":"partrelid","hidden":false,"name":"partrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Partitioning strategy; h = hash partitioned table, l = list partitioned table, r = range partitioned table","description_zh":"","documented":true,"documented_name":"partstrat","hidden":false,"name":"partstrat","not_null":true,"references":"","type":"char","type_modifier":-1,"type_oid":18},{"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},{"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":"","documented":true,"documented_name":"partdefid","hidden":false,"name":"partdefid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"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":"","documented":true,"documented_name":"partattrs","hidden":false,"name":"partattrs","not_null":true,"references":"pg_attribute.attnum","type":"int2vector","type_modifier":-1,"type_oid":22},{"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":"","documented":true,"documented_name":"partclass","hidden":false,"name":"partclass","not_null":true,"references":"pg_opclass.oid","type":"oidvector","type_modifier":-1,"type_oid":30},{"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":"","documented":true,"documented_name":"partcollation","hidden":false,"name":"partcollation","not_null":true,"references":"pg_collation.oid","type":"oidvector","type_modifier":-1,"type_oid":30},{"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":"","documented":true,"documented_name":"partexprs","hidden":false,"name":"partexprs","not_null":false,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194}],"description":"The catalog pg_partitioned_table stores information about how tables are partitioned.","description_zh":"","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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.39.4","file":"catalog-pg-partitioned-table.html","lang":"en","sha256":"1f1058fb4fb9566b3e21b5ee32fe9ca2eba728008dde2904df7e41719a49c687","slug":"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":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_partitioned_table","Summary":"目录pg_partitioned_table存放有关表如何被分区的信息。","BodyHTML":"\u003cp\u003e目录pg_partitioned_table存放有关表如何被分区的信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"25e0a089e096680cdd315c29ce74db40b2792d5d67f3d16ead8734691a554834","Payload":{"columns":[{"description_zh":"这个分区表的pg_class项的OID","name":"partrelid","type":"oid","zh_from":"doc"},{"description_zh":"分区策略；h = hash 分区表，l = 列表分区表，r = 范围分区表","name":"partstrat","type":"\"char\"","zh_from":"doc"},{"description_zh":"分区键中的列数","name":"partnatts","type":"smallint","zh_from":"doc"},{"description_zh":"这个分区表的默认分区的pg_class项的OID，如果这个分区表没有默认分区则为零。","name":"partdefid","type":"oid","zh_from":"doc"},{"description_zh":"这是一个包含 partnatts 个值的数组，它指示哪些表列是分区键的组成部分。例如，值1 3表示第一个和第三个表列组成了分区键。这个数组中的零表示对应的分区键列是一个表达式而不是简单的列引用。","name":"partattrs","type":"int2vector","zh_from":"doc"},{"description_zh":"对于分区键中的每一个列，此字段包含要使用的操作符类的OID。详见pg_opclass。","name":"partclass","type":"oidvector","zh_from":"doc"},{"description_zh":"对于分区键中的每一个列，此字段包含要用于分区的排序规则的OID，如果该列的数据类型不支持排序规则则为零。","name":"partcollation","type":"oidvector","zh_from":"doc"},{"description_zh":"非简单列引用的分区键列的表达式树（以nodeToString()的表达方式）。这是一个列表，partattrs中每一个零项都有一个元素。如果所有分区键列都是简单列引用，则此字段为 NULL。","name":"partexprs","type":"pg_node_tree","zh_from":"doc"}],"description_zh":"目录pg_partitioned_table存放有关表如何被分区的信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}