{"kind": "psql", "major": "18", "item": {"slug": "cmd-64-50", "name": "\\dP", "name_zh": "", "category": "\u63cf\u8ff0\u6570\u636e\u5e93\u5bf9\u8c61", "summary": "\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c pattern \u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002", "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+"], "content_hash": "040e30f1900647c8bef8b8924ee4199e989ec3d95bd1e1dc8b30c4d6db1cd344", "versions": {"12": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 12.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=12", "text": "\\dP"}, "modifiers": "itn+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=12", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/12/postgresql-12-A4.pdf", "bytes": 13424351, "pages": 2803, "sha256": "7422cf53fd1939e7a3d2925231a88b0330e468afa5393627cac0ff86158a0621", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/12/postgresql-12-US.pdf", "bytes": 13322565, "pages": 2958, "sha256": "51f3b04e72907fc38512685946223452ea65f84419c60c66241dfa3396035e77", "built_at": "2026-09-26"}}, "tree": "12", "index": "index.html", "major": "12", "pages": 1131, "release": "12.22", "source_url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "svg_assets": 2, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "revision": "7a827e97cbfacd7febff75f34443e2043e40723de5b6d8c9d81a9430b65a37e4", "evidence_kind": "English manual and source declarations", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "https://pg.center/docs/12/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "12.22 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "a5cec5a456a98610e98d1f1959d96ce57c8413bb392f0f5d6720fc561bb63627", "language": "en", "original_url": "/docs/12/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt><span class=\"term\"><code class=\"literal\">\\dP[itn+] [ <a class=\"link\" href=\"https://pg.center/docs/12/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span></dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86<em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4e86\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u4f1a\u5305\u542b\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u5217\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u5173\u7cfb\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0<code class=\"literal\">+</code>\uff0c\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u7684\u5404\u4e2a\u5206\u533a\u7684\u5927\u5c0f\u4e4b\u548c\uff0c\u4ee5\u53ca\u8be5\u5173\u7cfb\u7684\u63cf\u8ff0\u3002\u5982\u679c\u5c06<code class=\"literal\">n</code>\u4e0e<code class=\"literal\">+</code>\u7ed3\u5408\u4f7f\u7528\uff0c\u5219\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u662f\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5b50\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u662f\u6240\u6709\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u7684\u5b50\u5206\u533a\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/12/app-psql.html", "method": "same-major semantic node", "sha256": "1eb88d17f6ce811d722e5c4ed036f78a7872bf88410c08db794c428e3cfc98ce", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[69]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[69]/p[1]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[69]/p[2]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "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.", "/versions/12/facts/0/label": "Client", "/versions/12/facts/1/label": "Case-sensitive spelling", "/versions/12/tables/0/title": "Spellings in this manual definition", "/versions/12/related/0/label": "psql command-line options and complete manual", "/versions/12/tables/0/columns/0/label": "Command", "/versions/12/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "75c2c532c53406de205c287726d1655ff4fb01737d351d6dbe5d3c4272993e9a"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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 + 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."}, "comparison_hash": "2b4db251afc9fd06710da02bc403c7f1f02fbe2f91fecb4594aae81f07dde163", "manual_language": "zh"}, "13": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 13.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=13", "text": "\\dP"}, "modifiers": "itn+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=13", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/13/postgresql-13-A4.pdf", "bytes": 13843239, "pages": 2826, "sha256": "171cc09f90936dbc1cbd503a98ff07ae72ea58ab9771ff051313f1217737799c", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/13/postgresql-13-US.pdf", "bytes": 13739572, "pages": 2984, "sha256": "48d09c6e197d9db4220f41afe83efe848a8661b1b168d3b89419751ecaf6c24d", "built_at": "2026-09-26"}}, "tree": "13", "index": "index.html", "major": "13", "pages": 1139, "release": "13.23", "source_url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "revision": "614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6", "evidence_kind": "English manual and source declarations", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sources": [{"url": "https://pg.center/docs/13/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "13.23 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "30347083b7a58da020d968643e2479d2dfb534191d4493d454603ca53db151b0", "language": "en", "original_url": "/docs/13/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt><span class=\"term\"><code class=\"literal\">\\dP[itn+] [ <a class=\"link\" href=\"https://pg.center/docs/13/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span></dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86<em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4e86\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u4f1a\u5305\u542b\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u5217\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u5173\u7cfb\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0<code class=\"literal\">+</code>\uff0c\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u7684\u5404\u4e2a\u5206\u533a\u7684\u5927\u5c0f\u4e4b\u548c\uff0c\u4ee5\u53ca\u8be5\u5173\u7cfb\u7684\u63cf\u8ff0\u3002\u5982\u679c\u5c06<code class=\"literal\">n</code>\u4e0e<code class=\"literal\">+</code>\u7ed3\u5408\u4f7f\u7528\uff0c\u5219\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u662f\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5b50\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u662f\u6240\u6709\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u7684\u5b50\u5206\u533a\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/13/app-psql.html", "method": "same-major semantic node", "sha256": "dd2bf63d81b9a9d3fc69c646197cfdc14a0b1bab1c9f0b98608d66554da4a261", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[77]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[77]/p[1]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[77]/p[2]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "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.", "/versions/13/facts/0/label": "Client", "/versions/13/facts/1/label": "Case-sensitive spelling", "/versions/13/tables/0/title": "Spellings in this manual definition", "/versions/13/related/0/label": "psql command-line options and complete manual", "/versions/13/tables/0/columns/0/label": "Command", "/versions/13/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "fcf320a6f84d4b5a4277ea5ce8adc53a0ab2f611b12d897f7494a539919e1a01"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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 + 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."}, "comparison_hash": "2b4db251afc9fd06710da02bc403c7f1f02fbe2f91fecb4594aae81f07dde163", "manual_language": "zh"}, "14": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.24"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=14", "text": "\\dP"}, "modifiers": "itn+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=14", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/14/postgresql-14-A4.pdf", "bytes": 14354704, "pages": 2944, "sha256": "8bc6b9dd7b246888bb77f0a5e8c39a2eae52e9926569832669c7d1600becb27c", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/14/postgresql-14-US.pdf", "bytes": 14242178, "pages": 3102, "sha256": "b7ecb5a5f62d8b9f73a69e25a7d26ba285373bc53168a553bff7b77955506db4", "built_at": "2026-09-26"}}, "tree": "14", "index": "index.html", "major": "14", "pages": 1158, "release": "14.24", "source_url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "revision": "588700d46356d8837c77c7c0a4e71e645fe6535983b8f1830aa8f2e4e41c40ae", "evidence_kind": "English manual and source declarations", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sources": [{"url": "https://pg.center/docs/14/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "14.24 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "8da20abaee171c53c05658cfb2580dea645070f40bad6b46a845d710ad74c3ae", "language": "en", "original_url": "/docs/14/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt><span class=\"term\"><code class=\"literal\">\\dP[itn+] [ <a class=\"link\" href=\"https://pg.center/docs/14/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span></dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86<em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4e86\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u4f1a\u5305\u542b\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u5217\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u5173\u7cfb\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0<code class=\"literal\">+</code>\uff0c\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u7684\u5404\u4e2a\u5206\u533a\u7684\u5927\u5c0f\u4e4b\u548c\uff0c\u4ee5\u53ca\u8be5\u5173\u7cfb\u7684\u63cf\u8ff0\u3002\u5982\u679c\u5c06<code class=\"literal\">n</code>\u4e0e<code class=\"literal\">+</code>\u7ed3\u5408\u4f7f\u7528\uff0c\u5219\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u662f\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5b50\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u662f\u6240\u6709\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u7684\u5b50\u5206\u533a\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/14/app-psql.html", "method": "same-major semantic node", "sha256": "11c74f85ef9d2c9b3921e0c622d69dd3f1b3ed0c916197a94ddab5540153e310", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[77]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[77]/p[1]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[77]/p[2]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "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.", "/versions/14/facts/0/label": "Client", "/versions/14/facts/1/label": "Case-sensitive spelling", "/versions/14/tables/0/title": "Spellings in this manual definition", "/versions/14/related/0/label": "psql command-line options and complete manual", "/versions/14/tables/0/columns/0/label": "Command", "/versions/14/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "284bd0bac40859a02fe01ef895029858e16ec9eca6b7b160e38e7705259a4310"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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 + 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."}, "comparison_hash": "2b4db251afc9fd06710da02bc403c7f1f02fbe2f91fecb4594aae81f07dde163", "manual_language": "zh"}, "15": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.19"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=15", "text": "\\dP"}, "modifiers": "itn+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=15", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/15/postgresql-15-A4.pdf", "bytes": 14609140, "pages": 2987, "sha256": "66228564a4d16efb47d6a914085716ecfe22ca1566db56bc7c3d82f790646d72", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/15/postgresql-15-US.pdf", "bytes": 14495690, "pages": 3153, "sha256": "645a498c2390d47a6223ec74770631185807a19c484edb0fc5a295d9f460bc02", "built_at": "2026-09-26"}}, "tree": "15", "index": "index.html", "major": "15", "pages": 1168, "release": "15.19", "source_url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "revision": "6af958c6520151fc7697d56e0616b03fb00522c4568158674d452ae0644ba545", "evidence_kind": "English manual and source declarations", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sources": [{"url": "https://pg.center/docs/15/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "15.19 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "cb07228edb4914a53530afca316fd700a250cc062af2d5a74d24add93afbd0c8", "language": "en", "original_url": "/docs/15/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt><span class=\"term\"><code class=\"literal\">\\dP[itn+] [ <a class=\"link\" href=\"https://pg.center/docs/15/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span></dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86<em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4e86\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u4f1a\u5305\u542b\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u5217\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u5173\u7cfb\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0<code class=\"literal\">+</code>\uff0c\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u7684\u5404\u4e2a\u5206\u533a\u7684\u5927\u5c0f\u4e4b\u548c\uff0c\u4ee5\u53ca\u8be5\u5173\u7cfb\u7684\u63cf\u8ff0\u3002\u5982\u679c\u5c06<code class=\"literal\">n</code>\u4e0e<code class=\"literal\">+</code>\u7ed3\u5408\u4f7f\u7528\uff0c\u5219\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u662f\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5b50\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u662f\u6240\u6709\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u7684\u5b50\u5206\u533a\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/15/app-psql.html", "method": "same-major semantic node", "sha256": "8d6ed2e3400192f466dca73fd9423e91b9ede916fe0981b7e0cd42bc091394d2", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[79]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[79]/p[1]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[79]/p[2]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "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.", "/versions/15/facts/0/label": "Client", "/versions/15/facts/1/label": "Case-sensitive spelling", "/versions/15/tables/0/title": "Spellings in this manual definition", "/versions/15/related/0/label": "psql command-line options and complete manual", "/versions/15/tables/0/columns/0/label": "Command", "/versions/15/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f95b3ce23f2afb004f17e6e28a8649db3fe9283de11b16aefc83aff66ad90b13"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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 + 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."}, "comparison_hash": "2b4db251afc9fd06710da02bc403c7f1f02fbe2f91fecb4594aae81f07dde163", "manual_language": "zh"}, "16": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.15"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=16", "text": "\\dP"}, "modifiers": "itn+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/16/postgresql-16-A4.pdf", "bytes": 15282337, "pages": 3055, "sha256": "4bb6c1f63deedac98736d8c4c7bc0fad0ac24e85b07e21ee10411872f06afd06", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/16/postgresql-16-US.pdf", "bytes": 15164148, "pages": 3220, "sha256": "5b6b6166c89991199e144bb0ae34c17a5f29826251dbf19db1abc0df3a3e771b", "built_at": "2026-09-26"}}, "tree": "16", "index": "index.html", "major": "16", "pages": 1169, "release": "16.15", "source_url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "revision": "3c21e58b35318021716440e67bb8bafd392b6a2b965a244d90e9e33c99e0bdef", "evidence_kind": "English manual and source declarations", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DP-UC", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493", "language": "en", "original_url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DP-UC\"><span class=\"term\"><code class=\"literal\">\\dP[itn+] [ <a class=\"link\" href=\"https://pg.center/docs/16/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86<em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4e86\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u4f1a\u5305\u542b\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u5217\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u5173\u7cfb\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0<code class=\"literal\">+</code>\uff0c\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u7684\u5404\u4e2a\u5206\u533a\u7684\u5927\u5c0f\u4e4b\u548c\uff0c\u4ee5\u53ca\u8be5\u5173\u7cfb\u7684\u63cf\u8ff0\u3002\u5982\u679c\u5c06<code class=\"literal\">n</code>\u4e0e<code class=\"literal\">+</code>\u7ed3\u5408\u4f7f\u7528\uff0c\u5219\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u662f\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5b50\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u662f\u6240\u6709\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u7684\u5b50\u5206\u533a\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/16/app-psql.html", "method": "same-major semantic node", "sha256": "72833cd861534255277e73a650a16ab07f11c38db9df980213b8335751a3273d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[81]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[81]/p[1]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[81]/p[2]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "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.", "/versions/16/facts/0/label": "Client", "/versions/16/facts/1/label": "Case-sensitive spelling", "/versions/16/tables/0/title": "Spellings in this manual definition", "/versions/16/related/0/label": "psql command-line options and complete manual", "/versions/16/tables/0/columns/0/label": "Command", "/versions/16/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "52b99a169504e404cdab775947b1c0ae6a97298b9d868179ddd35f3c0574fec7"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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 + 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."}, "comparison_hash": "2b4db251afc9fd06710da02bc403c7f1f02fbe2f91fecb4594aae81f07dde163", "manual_language": "zh"}, "17": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.11"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=17", "text": "\\dP"}, "modifiers": "itn+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/17/postgresql-17-A4.pdf", "bytes": 15521293, "pages": 3099, "sha256": "1991354df0dc89e70ec39328c28988ef8b19c6a93671dab3893650b63e9f4e36", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/17/postgresql-17-US.pdf", "bytes": 15398150, "pages": 3270, "sha256": "07696c8f38abf31babf22d2db337093936e7c472d2af36d050b000c49bbcf52c", "built_at": "2026-09-26"}}, "tree": "17", "index": "index.html", "major": "17", "pages": 1143, "release": "17.11", "source_url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "revision": "58419c9b0dd42cb34c8d53695bb025a7e582edf55ccd4c5bcb1c2c7c71a37487", "evidence_kind": "English manual and source declarations", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "https://pg.center/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DP-UC", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b", "language": "en", "original_url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DP-UC\"><span class=\"term\"><code class=\"literal\">\\dP[itn+] [ <a class=\"link\" href=\"https://pg.center/docs/17/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c\u6307\u5b9a\u4e86<em class=\"replaceable\"><code>pattern</code></em>\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6761\u76ee\u3002\u53ef\u4ee5\u5728\u547d\u4ee4\u540e\u9644\u52a0\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\uff0c\u7b5b\u9009\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u4f1a\u5217\u51fa\u5206\u533a\u8868\u548c\u5206\u533a\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4e86\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u4f1a\u5305\u542b\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u5217\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u5173\u7cfb\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0<code class=\"literal\">+</code>\uff0c\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u7684\u5404\u4e2a\u5206\u533a\u7684\u5927\u5c0f\u4e4b\u548c\uff0c\u4ee5\u53ca\u8be5\u5173\u7cfb\u7684\u63cf\u8ff0\u3002\u5982\u679c\u5c06<code class=\"literal\">n</code>\u4e0e<code class=\"literal\">+</code>\u7ed3\u5408\u4f7f\u7528\uff0c\u5219\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u662f\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5b50\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u662f\u6240\u6709\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u7684\u5b50\u5206\u533a\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/17/app-psql.html", "method": "same-major semantic node", "sha256": "820a5ee48a79666cef06bfe375ea9337e7a347b6d32c921738edd824fe5aa9f8", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[81]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[81]/p[1]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[81]/p[2]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "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.", "/versions/17/facts/0/label": "Client", "/versions/17/facts/1/label": "Case-sensitive spelling", "/versions/17/tables/0/title": "Spellings in this manual definition", "/versions/17/related/0/label": "psql command-line options and complete manual", "/versions/17/tables/0/columns/0/label": "Command", "/versions/17/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "9e343305b472ef2c741a7c390e4b39d7fff5481ae50b83c2e0f2d4e0f9b4334c"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itn+"}], "signature": "\\dP[itn+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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 + 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."}, "comparison_hash": "2b4db251afc9fd06710da02bc403c7f1f02fbe2f91fecb4594aae81f07dde163", "manual_language": "zh"}, "18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=18", "text": "\\dP"}, "modifiers": "itnx+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DP-UC", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c pattern \u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DP-UC\"><span class=\"term\"><code class=\"literal\">\\dP[itnx+] [ <a class=\"link\" href=\"https://pg.center/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c<em class=\"replaceable\"><code>pattern</code></em>\u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u5c06\u5305\u62ec\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u7ed9\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u7ea7\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u5206\u533a\u5927\u5c0f\u7684\u603b\u548c\u4ee5\u53ca\u5173\u7cfb\u63cf\u8ff0\u3002\u5982\u679c <code class=\"literal\">n</code> \u4e0e <code class=\"literal\">+</code> \u7ec4\u5408\u4f7f\u7528\uff0c\u5219\u4f1a\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u5305\u62ec\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u663e\u793a\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u5b50\u5206\u533a\u5728\u5185\u7684\u6240\u6709\u5206\u533a\u603b\u5927\u5c0f\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "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.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "8a0659e60e2bf6eb2c4bc1a017366a7e65b0a1c5a95d5235fed0672d4d94620f"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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."}, "comparison_hash": "92ca5944dd6072d812d6fbcfa85821e34c0fd46951d6dec2bf596b431a23b85b", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=19", "text": "\\dP"}, "modifiers": "itnx+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DP-UC", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c pattern \u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DP-UC\"><span class=\"term\"><code class=\"literal\">\\dP[itnx+] [ <a class=\"link\" href=\"https://pg.center/docs/19/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c<em class=\"replaceable\"><code>pattern</code></em>\u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u5c06\u5305\u62ec\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u7ed9\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u7ea7\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u5206\u533a\u5927\u5c0f\u7684\u603b\u548c\u4ee5\u53ca\u5173\u7cfb\u63cf\u8ff0\u3002\u5982\u679c <code class=\"literal\">n</code> \u4e0e <code class=\"literal\">+</code> \u7ec4\u5408\u4f7f\u7528\uff0c\u5219\u4f1a\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u5305\u62ec\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u663e\u793a\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u5b50\u5206\u533a\u5728\u5185\u7684\u6240\u6709\u5206\u533a\u603b\u5927\u5c0f\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/19/app-psql.html", "method": "same-major semantic node", "sha256": "1351be06967585f99a84454a26dff346091ea378daf6c7ed9fa18edee9d1131c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[2]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "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.", "/versions/19/facts/0/label": "Client", "/versions/19/facts/1/label": "Case-sensitive spelling", "/versions/19/tables/0/title": "Spellings in this manual definition", "/versions/19/related/0/label": "psql command-line options and complete manual", "/versions/19/tables/0/columns/0/label": "Command", "/versions/19/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "3966f991908d1690f1366410db58356842de14656ce6da403432159e83a1f657"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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."}, "comparison_hash": "92ca5944dd6072d812d6fbcfa85821e34c0fd46951d6dec2bf596b431a23b85b", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=20", "text": "\\dP"}, "modifiers": "itnx+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DP-UC", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c pattern \u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DP-UC\"><span class=\"term\"><code class=\"literal\">\\dP[itnx+] [ <a class=\"link\" href=\"https://pg.center/docs/devel/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c<em class=\"replaceable\"><code>pattern</code></em>\u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u5c06\u5305\u62ec\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u7ed9\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u7ea7\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u5206\u533a\u5927\u5c0f\u7684\u603b\u548c\u4ee5\u53ca\u5173\u7cfb\u63cf\u8ff0\u3002\u5982\u679c <code class=\"literal\">n</code> \u4e0e <code class=\"literal\">+</code> \u7ec4\u5408\u4f7f\u7528\uff0c\u5219\u4f1a\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u5305\u62ec\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u663e\u793a\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u5b50\u5206\u533a\u5728\u5185\u7684\u6240\u6709\u5206\u533a\u603b\u5927\u5c0f\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/app-psql.html", "method": "same-major semantic node", "sha256": "1590b6e290ad21fe3ac1c1549628841ae426d1cd07a8f808789207878dbee5ab", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[2]"]}], "language": "zh", "original_text": {"/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.", "/category": "Describe database objects", "/versions/20/description/0": "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.", "/versions/20/facts/0/label": "Client", "/versions/20/facts/1/label": "Case-sensitive spelling", "/versions/20/tables/0/title": "Spellings in this manual definition", "/versions/20/related/0/label": "psql command-line options and complete manual", "/versions/20/tables/0/columns/0/label": "Command", "/versions/20/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "3b4b59494b394f3716fa517ce57adbe4d5b110d976cb5f8858020ba89ed23c8f"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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."}, "comparison_hash": "92ca5944dd6072d812d6fbcfa85821e34c0fd46951d6dec2bf596b431a23b85b", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dP"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-50/?v=18", "text": "\\dP"}, "modifiers": "itnx+"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\dP", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DP-UC", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DP-UC"}], "sections": [], "modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "description": ["\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c pattern \u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26 t \uff08\u8868\uff09\u548c i \uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMAND-DP-UC\"><span class=\"term\"><code class=\"literal\">\\dP[itnx+] [ <a class=\"link\" href=\"https://pg.center/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"><em class=\"replaceable\"><code>pattern</code></em></a> ]</code></span> </dt><dd>\n<p lang=\"zh\">\u5217\u51fa\u5206\u533a\u5173\u7cfb\u3002\u5982\u679c<em class=\"replaceable\"><code>pattern</code></em>\u88ab\u6307\u5b9a\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6761\u76ee\u3002\u4fee\u9970\u7b26<code class=\"literal\">t</code>\uff08\u8868\uff09\u548c<code class=\"literal\">i</code>\uff08\u7d22\u5f15\uff09\u53ef\u4ee5\u9644\u52a0\u5230\u547d\u4ee4\uff0c\u8fc7\u6ee4\u8981\u5217\u51fa\u7684\u5173\u7cfb\u7c7b\u578b\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5217\u51fa\u5206\u533a\u8868\u548c\u7d22\u5f15\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u4f7f\u7528\u4fee\u9970\u7b26<code class=\"literal\">n</code>\uff08<span class=\"quote\">\u201c<span class=\"quote\">nested</span>\u201d</span>\uff09\uff0c\u6216\u6307\u5b9a\u4e86\u6a21\u5f0f\uff0c\u5219\u5c06\u5305\u62ec\u975e\u6839\u5206\u533a\u5173\u7cfb\uff0c\u5e76\u663e\u793a\u4e00\u5217\uff0c\u7ed9\u51fa\u6bcf\u4e2a\u5206\u533a\u5173\u7cfb\u7684\u7236\u7ea7\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">x</code>\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 <code class=\"literal\">+</code>\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6bcf\u4e2a\u5173\u7cfb\u5206\u533a\u5927\u5c0f\u7684\u603b\u548c\u4ee5\u53ca\u5173\u7cfb\u63cf\u8ff0\u3002\u5982\u679c <code class=\"literal\">n</code> \u4e0e <code class=\"literal\">+</code> \u7ec4\u5408\u4f7f\u7528\uff0c\u5219\u4f1a\u663e\u793a\u4e24\u4e2a\u5927\u5c0f\uff1a\u4e00\u4e2a\u5305\u62ec\u76f4\u63a5\u9644\u52a0\u7684\u53f6\u5206\u533a\u7684\u603b\u5927\u5c0f\uff0c\u53e6\u4e00\u4e2a\u663e\u793a\u5305\u62ec\u95f4\u63a5\u9644\u52a0\u5b50\u5206\u533a\u5728\u5185\u7684\u6240\u6709\u5206\u533a\u603b\u5927\u5c0f\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DP-UC", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[1]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[85]/p[2]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "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.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "8a0659e60e2bf6eb2c4bc1a017366a7e65b0a1c5a95d5235fed0672d4d94620f"}, "comparison_data": {"modifiers": [{"command": "\\dP", "modifiers": "itnx+"}], "signature": "\\dP[itnx+] [ pattern ]", "spellings": ["\\dP"], "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 ( \u201c nested \u201d ) 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."}, "comparison_hash": "92ca5944dd6072d812d6fbcfa85821e34c0fd46951d6dec2bf596b431a23b85b", "manual_language": "zh"}, "comparison": {"left": "11", "right": "12", "status": "added", "diff": "--- PostgreSQL 11\n+++ PostgreSQL 12\n@@ -1 +1,13 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"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 ( \u201c nested \u201d ) 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 + 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.\",\n+  \"modifiers\": [\n+    {\n+      \"command\": \"\\\\dP\",\n+      \"modifiers\": \"itn+\"\n+    }\n+  ],\n+  \"signature\": \"\\\\dP[itn+] [ pattern ]\",\n+  \"spellings\": [\n+    \"\\\\dP\"\n+  ]\n+}"}}