{"Entry":{"collection":"psql","key":"cmd-64-50","name":"\\dP","aliases":["\\dP","\\dP+","\\dPi","\\dPi+","\\dPin","\\dPin+","\\dPinx","\\dPinx+","\\dPit","\\dPit+","\\dPitn","\\dPitn+","\\dPitnx","\\dPitnx+","\\dPitx","\\dPitx+","\\dPix","\\dPix+","\\dPn","\\dPn+","\\dPnx","\\dPnx+","\\dPt","\\dPt+","\\dPtn","\\dPtn+","\\dPtnx","\\dPtnx+","\\dPtx","\\dPtx+","\\dPx","\\dPx+"],"metadata":{"aliases":["\\dP","\\dP+","\\dPi","\\dPi+","\\dPin","\\dPin+","\\dPinx","\\dPinx+","\\dPit","\\dPit+","\\dPitn","\\dPitn+","\\dPitnx","\\dPitnx+","\\dPitx","\\dPitx+","\\dPix","\\dPix+","\\dPn","\\dPn+","\\dPnx","\\dPnx+","\\dPt","\\dPt+","\\dPtn","\\dPtn+","\\dPtnx","\\dPtnx+","\\dPtx","\\dPtx+","\\dPx","\\dPx+"],"category":"Describe database objects","content_hash":"7b5710834756604bf4cfa2f1e10c771c209aad574840beca66d22490e1c2b892","derived_content_hash":"310cf0c4bd7723f97b1454dd1010afa54511b50c2a4b08cf228aec9e4e9aa1e7","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:44.818658+08:00","name":"\\dP","name_zh":"","slug":"cmd-64-50","summary":"Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed."}},"Definition":{"Collection":"psql","Key":"cmd-64-50","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-50","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\dP","comparison_data":{"definition":"Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed. If the modifier n ( “ nested ” ) is used, or a pattern is specified, then non-root partitioned relations are included, and a column is shown displaying the parent of each partitioned relation. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, the sum of the sizes of each relation's partitions is also displayed, along with the relation's description. If n is combined with + , two sizes are shown: one including the total size of directly-attached leaf partitions, and another showing the total size of all partitions, including indirectly attached sub-partitions.","modifiers":[{"command":"\\dP","modifiers":"itnx+"}],"signature":"\\dP[itnx+] [ pattern ]","spellings":["\\dP"]},"comparison_hash":"92ca5944dd6072d812d6fbcfa85821e34c0fd46951d6dec2bf596b431a23b85b","description":["Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed."],"description_zh":"列出分区关系。如果 pattern 被指定，则只列出名称与模式匹配的条目。修饰符 t （表）和 i （索引）可以附加到命令，过滤要列出的关系类型。默认情况下，列出分区表和索引。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        列出分区关系。如果 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 被指定，则只列出名称与模式匹配的条目。修饰符 \u003ccode class=\"literal\"\u003et\u003c/code\u003e（表）和 \u003ccode class=\"literal\"\u003ei\u003c/code\u003e（索引）可以附加到命令，过滤要列出的关系类型。默认情况下，列出分区表和索引。\n        \u003c/p\u003e\u003cp\u003e\n        如果使用修饰符 \u003ccode class=\"literal\"\u003en\u003c/code\u003e（\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003enested\u003c/span\u003e”\u003c/span\u003e），或指定了模式，则将包括非根分区关系，并显示一列，给出每个分区关系的父级。\n        \u003c/p\u003e\u003cp\u003e\n        如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。如果在命令名后追加 \u003ccode class=\"literal\"\u003e+\u003c/code\u003e，则还会显示每个关系分区大小的总和以及关系描述。如果 \u003ccode class=\"literal\"\u003en\u003c/code\u003e 与 \u003ccode class=\"literal\"\u003e+\u003c/code\u003e 组合使用，则会显示两个大小：一个包括直接附加的叶分区的总大小，另一个显示包括间接附加子分区在内的所有分区总大小。\n        \u003c/p\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\dP"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\dP"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DP-UC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dP[itnx+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists partitioned relations.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\n        is specified, only entries whose name matches the pattern are listed.\n        The modifiers \u003ccode class=\"literal\"\u003et\u003c/code\u003e (tables) and \u003ccode class=\"literal\"\u003ei\u003c/code\u003e\n        (indexes) can be appended to the command, filtering the kind of\n        relations to list.  By default, partitioned tables and indexes are\n        listed.\n        \u003c/p\u003e\u003cp\u003e\n        If the modifier \u003ccode class=\"literal\"\u003en\u003c/code\u003e (\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003enested\u003c/span\u003e”\u003c/span\u003e) is used,\n        or a pattern is specified, then non-root partitioned relations are\n        included, and a column is shown displaying the parent of each\n        partitioned relation.\n        \u003c/p\u003e\u003cp\u003e\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, the sum of the\n        sizes of each relation's partitions is also displayed, along with the\n        relation's description.\n        If \u003ccode class=\"literal\"\u003en\u003c/code\u003e is combined with \u003ccode class=\"literal\"\u003e+\u003c/code\u003e, two\n        sizes are shown: one including the total size of directly-attached\n        leaf partitions, and another showing the total size of all partitions,\n        including indirectly attached sub-partitions.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DP-UC","modifiers":[{"command":"\\dP","modifiers":"itnx+"}],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\dP[itnx+] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DP-UC","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}],"spellings":["\\dP"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\dP","url":"/wiki/psql/cmd-64-50/?v=18"},"modifiers":"itnx+"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\dP","url":"/wiki/psql/cmd-64-50/?v=18"},"modifiers":"itnx+"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DP-UC","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-DP-UC","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-50","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\dP","Summary":"Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DP-UC\"\u003e\u003cspan\u003e\u003ccode\u003e\\dP[itnx+] [ \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003e\u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists partitioned relations.\n        If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\n        is specified, only entries whose name matches the pattern are listed.\n        The modifiers \u003ccode\u003et\u003c/code\u003e (tables) and \u003ccode\u003ei\u003c/code\u003e\n        (indexes) can be appended to the command, filtering the kind of\n        relations to list.  By default, partitioned tables and indexes are\n        listed.\n        \u003c/p\u003e\u003cp\u003e\n        If the modifier \u003ccode\u003en\u003c/code\u003e (\u003cspan\u003e“\u003cspan\u003enested\u003c/span\u003e”\u003c/span\u003e) is used,\n        or a pattern is specified, then non-root partitioned relations are\n        included, and a column is shown displaying the parent of each\n        partitioned relation.\n        \u003c/p\u003e\u003cp\u003e\n        If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode\u003e+\u003c/code\u003e is appended to the command name, the sum of the\n        sizes of each relation\u0026#39;s partitions is also displayed, along with the\n        relation\u0026#39;s description.\n        If \u003ccode\u003en\u003c/code\u003e is combined with \u003ccode\u003e+\u003c/code\u003e, two\n        sizes are shown: one including the total size of directly-attached\n        leaf partitions, and another showing the total size of all partitions,\n        including indirectly attached sub-partitions.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"45103dbb994697d68ac427e5874a36369d573690abf052ca8913ef8cb62d6085","Payload":{"description":["Lists partitioned relations. If pattern is specified, only entries whose name matches the pattern are listed. The modifiers t (tables) and i (indexes) can be appended to the command, filtering the kind of relations to list. By default, partitioned tables and indexes are listed."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DP-UC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\dP[itnx+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists partitioned relations.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\n        is specified, only entries whose name matches the pattern are listed.\n        The modifiers \u003ccode class=\"literal\"\u003et\u003c/code\u003e (tables) and \u003ccode class=\"literal\"\u003ei\u003c/code\u003e\n        (indexes) can be appended to the command, filtering the kind of\n        relations to list.  By default, partitioned tables and indexes are\n        listed.\n        \u003c/p\u003e\u003cp\u003e\n        If the modifier \u003ccode class=\"literal\"\u003en\u003c/code\u003e (\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003enested\u003c/span\u003e”\u003c/span\u003e) is used,\n        or a pattern is specified, then non-root partitioned relations are\n        included, and a column is shown displaying the parent of each\n        partitioned relation.\n        \u003c/p\u003e\u003cp\u003e\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, the sum of the\n        sizes of each relation's partitions is also displayed, along with the\n        relation's description.\n        If \u003ccode class=\"literal\"\u003en\u003c/code\u003e is combined with \u003ccode class=\"literal\"\u003e+\u003c/code\u003e, two\n        sizes are shown: one including the total size of directly-attached\n        leaf partitions, and another showing the total size of all partitions,\n        including indirectly attached sub-partitions.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\dP","url":"/wiki/psql/cmd-64-50/?v=18"},"modifiers":"itnx+"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\dP","Signature":"\\dP[itnx+] [ pattern ]","Modifiers":[{"command":"\\dP","modifiers":"itnx+"}]}],"SQLState":null,"Evidence":null}