{"Entry":{"collection":"func","key":"pg-partition-tree","name":"pg_partition_tree","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"11","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"12"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"edee6c35df59fe77a2f9a10aa4b334aeb02b181f1667643c46c3589482ae78e6","first_version":"12","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.597633+08:00","last_version":"20","name":"pg_partition_tree","name_key":"pg_partition_tree","position":29072,"present_in":["12","13","14","15","16","17","18","19","20"],"signature":"pg_partition_tree ( regclass ) → setof record ( relid regclass, parentrelid regclass, isleaf boolean, level integer )","signature_count":1,"slug":"pg-partition-tree","source_rev":"b7bd9cda","summary":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-partition-tree","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-partition-tree","SourceRevision":"b7bd9cda","Facts":{"description":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition. Information provided includes the OID of the partition, the OID of its immediate parent, a boolean value telling if the partition is a leaf, and an integer telling its level in the hierarchy. The level value is 0 for the input table or index, 1 for its immediate child partitions, 2 for their partitions, and so on. Returns no rows if the relation does not exist or is not a partition or partitioned table.","description_html":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition. Information provided includes the OID of the partition, the OID of its immediate parent, a boolean value telling if the partition is a leaf, and an integer telling its level in the hierarchy. The level value is 0 for the input table or index, 1 for its immediate child partitions, 2 for their partitions, and so on. Returns no rows if the relation does not exist or is not a partition or partitioned table.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-PARTITION","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition. Information provided includes the OID of the partition, the OID of its immediate parent, a boolean value telling if the partition is a leaf, and an integer telling its level in the hierarchy. The level value is 0 for the input table or index, 1 for its immediate child partitions, 2 for their partitions, and so on. Returns no rows if the relation does not exist or is not a partition or partitioned table.","description_html":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition. Information provided includes the OID of the partition, the OID of its immediate parent, a boolean value telling if the partition is a leaf, and an integer telling its level in the hierarchy. The level value is 0 for the input table or index, 1 for its immediate child partitions, 2 for their partitions, and so on. Returns no rows if the relation does not exist or is not a partition or partitioned table.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_partition_tree\u003c/code\u003e ( \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003erelid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eparentrelid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eisleaf\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elevel\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e )","returns":"setof record","text":"pg_partition_tree ( regclass ) → setof record ( relid regclass, parentrelid regclass, isleaf boolean, level integer )","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-PARTITION","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-partition-tree","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_partition_tree","Summary":"列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。","BodyHTML":"列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。\u003cpre\u003epg_partition_tree ( regclass ) → setof record ( relid regclass, parentrelid regclass, isleaf boolean, level integer )\u003c/pre\u003e列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。","SourceRevision":"ca936764","ContentHash":"e815fb3406fa4b0b260e078d7a6e8f06bbd54edb60cbe11bcbc98564410a17a6","Payload":{"description_zh":"列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。","description_zh_html":"列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。","signatures":[{"description_zh":"列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。","description_zh_html":"列出给定分区表或分区索引的分区树中的表或索引，每行对应一个分区。提供的信息包括分区的OID、其直接父的OID、一个布尔值以告知分区是否是叶子，以及一个整数用来告诉分区在层次结构中的级别。对于输入表或索引，级别值为0，其直接子分区的为1，它们的分区为2，以此类推。如果关系不存在，或者不是分区或分区表，则不返回行。","returns":"setof record","text":"pg_partition_tree ( regclass ) → setof record ( relid regclass, parentrelid regclass, isleaf boolean, level integer )","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"eddfc02e00184f9ab8bc0f4ef36dae6611e2f6fe8a32f2bec62642579f9c1572","Text":"pg_partition_tree ( regclass ) → setof record ( relid regclass, parentrelid regclass, isleaf boolean, level integer )","Returns":"setof record","Payload":{"description":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition. Information provided includes the OID of the partition, the OID of its immediate parent, a boolean value telling if the partition is a leaf, and an integer telling its level in the hierarchy. The level value is 0 for the input table or index, 1 for its immediate child partitions, 2 for their partitions, and so on. Returns no rows if the relation does not exist or is not a partition or partitioned table.","description_html":"Lists the tables or indexes in the partition tree of the given partitioned table or partitioned index, with one row for each partition. Information provided includes the OID of the partition, the OID of its immediate parent, a boolean value telling if the partition is a leaf, and an integer telling its level in the hierarchy. The level value is 0 for the input table or index, 1 for its immediate child partitions, 2 for their partitions, and so on. Returns no rows if the relation does not exist or is not a partition or partitioned table.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_partition_tree\u003c/code\u003e ( \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003erelid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eparentrelid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eregclass\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eisleaf\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003elevel\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e )","returns":"setof record","text":"pg_partition_tree ( regclass ) → setof record ( relid regclass, parentrelid regclass, isleaf boolean, level integer )","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}