{"kind": "psql", "major": "18", "item": {"slug": "cmd-64-6d", "name": "\\dm", "name_zh": "", "category": "\u63cf\u8ff0\u6570\u636e\u5e93\u5bf9\u8c61", "summary": "\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002", "aliases": ["\\dm", "\\dm+", "\\dmS", "\\dmS+", "\\dmSx", "\\dmSx+", "\\dmx", "\\dmx+"], "content_hash": "61bac1b378cbb6f3277bd8e13d748f7289a57cafa8b95a03521f3ca6c88332b0", "versions": {"10": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 10.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=10", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=10", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=10", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=10", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=10", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=10", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=10", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=10", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=10", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=10", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=10", "label": "\\dv"}, {"url": "/wiki/tool/psql/?v=10", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/10/postgresql-10-A4.pdf", "bytes": 12631706, "pages": 2591, "sha256": "34497ab9efb45c5bdf1bd11b9016b5451354feb462fa029cf74557a5fa5fbbc1", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/10/postgresql-10-US.pdf", "bytes": 12531684, "pages": 2724, "sha256": "429cc7133ddf4f97c560aa466dc9caea4b718721a8321e293357037cf0af4733", "built_at": "2026-09-26"}}, "tree": "10", "index": "index.html", "major": "10", "pages": 1085, "release": "10.23", "source_url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "svg_assets": 0, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "revision": "f9301feba91e2e2566038a36b8cee0e4402db68989538f88670fddd20b1f78ea", "evidence_kind": "English manual and source declarations", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "sources": [{"url": "https://pg.center/docs/10/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "10.23 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "9e11fe3148cb8c085808f632ed972aa4514332a67758a083a080169101eeb7a4", "language": "en", "original_url": "/docs/10/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u4ee3\u8868\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u8fd9\u4e9b\u5b57\u6bcd\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a\u6216\u5168\u90e8\uff0c\u4ee5\u83b7\u53d6\u76f8\u5e94\u7c7b\u578b\u7684\u5bf9\u8c61\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dit \u5217\u51fa\u7d22\u5f15\u548c\u8868\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u5217\u51fa\u6bcf\u4e2a\u5bf9\u8c61\u7684\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u5173\u8054\u7684\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u542b\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcdE\u3001i\u3001m\u3001s\u3001t\u548cv\u5206\u522b\u4ee3\u8868\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u8fd9\u4e9b\u5b57\u6bcd\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a\u6216\u5168\u90e8\uff0c\u4ee5\u83b7\u53d6\u76f8\u5e94\u7c7b\u578b\u7684\u5bf9\u8c61\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dit\u5217\u51fa\u7d22\u5f15\u548c\u8868\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u5217\u51fa\u6bcf\u4e2a\u5bf9\u8c61\u7684\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u5173\u8054\u7684\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216S\u4fee\u9970\u7b26\u53ef\u5305\u542b\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/10/app-psql.html", "method": "same-major semantic node", "sha256": "07e2383663e136e49c565dc43b76b773af4caa89393ce1854d32ec8cc15f2d3c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[35]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dit lists indexes and tables. If + is appended to the command name, each object is listed with its physical size on disk and its associated description, if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/versions/10/facts/0/label": "Client", "/versions/10/facts/1/label": "Case-sensitive spelling", "/versions/10/tables/0/title": "Spellings in this manual definition", "/versions/10/related/5/label": "psql command-line options and complete manual", "/versions/10/tables/0/columns/0/label": "Command", "/versions/10/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "2d2eed3687bfc688fd1e40c819f3a70abbfc0edabcbb52666eee1554ef0d193e"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dit lists indexes and tables. If + is appended to the command name, each object is listed with its physical size on disk and its associated description, if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "465f46a2900a3bb0a0b507de1f2948472622a485af1dae92671302da775ccb94", "manual_language": "zh"}, "11": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 11.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=11", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=11", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=11", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=11", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=11", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=11", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=11", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=11", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=11", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=11", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=11", "label": "\\dv"}, {"url": "/wiki/tool/psql/?v=11", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/11/postgresql-11-A4.pdf", "bytes": 13057499, "pages": 2732, "sha256": "41d75855e610d0d9b8802b87dc5b080bef8d7e91c7cf69401fbf8d3cf801b4b5", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/11/postgresql-11-US.pdf", "bytes": 12961189, "pages": 2883, "sha256": "6a8899ef36935a5b7ed2b436207564a567a4ef1eb1c2200195876b8de4d4fa30", "built_at": "2026-09-26"}}, "tree": "11", "index": "index.html", "major": "11", "pages": 1125, "release": "11.22", "source_url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "svg_assets": 0, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "revision": "53315ddaf3b3f9e6669fd1edc096bbb2cd4a65ea3e836c89e542b43af9ba3a7f", "evidence_kind": "English manual and source declarations", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "sources": [{"url": "https://pg.center/docs/11/app-psql.html#APP-PSQL-META-COMMANDS", "file": "app-psql.html", "label": "11.22 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS", "sha256": "32c4d489e91e59715de2f7c3264fcccab3dd1eca54673dbfeac61304b0c54d4d", "language": "en", "original_url": "/docs/11/app-psql.html#APP-PSQL-META-COMMANDS"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u4ee3\u8868\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u8fd9\u4e9b\u5b57\u6bcd\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a\u6216\u5168\u90e8\uff0c\u4ee5\u83b7\u53d6\u76f8\u5e94\u7c7b\u578b\u7684\u5bf9\u8c61\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dit \u5217\u51fa\u7d22\u5f15\u548c\u8868\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u5217\u51fa\u6bcf\u4e2a\u5bf9\u8c61\u7684\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u5173\u8054\u7684\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u542b\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcdE\u3001i\u3001m\u3001s\u3001t\u548cv\u5206\u522b\u4ee3\u8868\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u8fd9\u4e9b\u5b57\u6bcd\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a\u6216\u5168\u90e8\uff0c\u4ee5\u83b7\u53d6\u76f8\u5e94\u7c7b\u578b\u7684\u5bf9\u8c61\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dit\u5217\u51fa\u7d22\u5f15\u548c\u8868\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u5217\u51fa\u6bcf\u4e2a\u5bf9\u8c61\u7684\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u5173\u8054\u7684\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216S\u4fee\u9970\u7b26\u53ef\u5305\u542b\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS", "localization": {"status": "complete", "sources": [{"url": "/docs/11/app-psql.html", "method": "same-major semantic node", "sha256": "01339254dd1dc30d095af846d0b6a7c01f96338187a6fbb8cf45290d5941196b", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[35]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dit lists indexes and tables. If + is appended to the command name, each object is listed with its physical size on disk and its associated description, if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/versions/11/facts/0/label": "Client", "/versions/11/facts/1/label": "Case-sensitive spelling", "/versions/11/tables/0/title": "Spellings in this manual definition", "/versions/11/related/5/label": "psql command-line options and complete manual", "/versions/11/tables/0/columns/0/label": "Command", "/versions/11/tables/0/columns/1/label": "Documented suffix modifiers"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "db0c0daac4ce4727ad78e0fcb09d3cfcf8decf853ec0c30df6d46108acdf853d"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dit lists indexes and tables. If + is appended to the command name, each object is listed with its physical size on disk and its associated description, if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "465f46a2900a3bb0a0b507de1f2948472622a485af1dae92671302da775ccb94", "manual_language": "zh"}, "12": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 12.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=12", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=12", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=12", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=12", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=12", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=12", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=12", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=12", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=12", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=12", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=12", "label": "\\dv"}, {"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": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u4ee3\u8868\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u8fd9\u4e9b\u5b57\u6bcd\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a\u6216\u5168\u90e8\uff0c\u4ee5\u83b7\u53d6\u76f8\u5e94\u7c7b\u578b\u7684\u5bf9\u8c61\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dit \u5217\u51fa\u7d22\u5f15\u548c\u8868\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u5217\u51fa\u6bcf\u4e2a\u5bf9\u8c61\u7684\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u5173\u8054\u7684\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u542b\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcdE\u3001i\u3001m\u3001s\u3001t\u548cv\u5206\u522b\u4ee3\u8868\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u8fd9\u4e9b\u5b57\u6bcd\u4e2d\u7684\u4efb\u610f\u4e00\u4e2a\u6216\u5168\u90e8\uff0c\u4ee5\u83b7\u53d6\u76f8\u5e94\u7c7b\u578b\u7684\u5bf9\u8c61\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dit\u5217\u51fa\u7d22\u5f15\u548c\u8868\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u5217\u51fa\u6bcf\u4e2a\u5bf9\u8c61\u7684\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u5173\u8054\u7684\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216S\u4fee\u9970\u7b26\u53ef\u5305\u542b\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "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[35]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dit lists indexes and tables. If + is appended to the command name, each object is listed with its physical size on disk and its associated description, if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "55f923e6b31d267b156fd672852e8b9fbda3126048f57214d44c085f4ff88601"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dit lists indexes and tables. If + is appended to the command name, each object is listed with its physical size on disk and its associated description, if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "465f46a2900a3bb0a0b507de1f2948472622a485af1dae92671302da775ccb94", "manual_language": "zh"}, "13": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 13.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=13", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=13", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=13", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=13", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=13", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=13", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=13", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=13", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=13", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=13", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=13", "label": "\\dv"}, {"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": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "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[43]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "47175f9ec39e615d063f375d9e8352b3b0071e5b24f7abd4c31ad48cbdfe0ba8"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "6c0d6ea3c1f7e13b183019855bee7991e3479c9e2a47d79cd521eef82dfd55f3", "manual_language": "zh"}, "14": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.24"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=14", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=14", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=14", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=14", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=14", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=14", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=14", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=14", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=14", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=14", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=14", "label": "\\dv"}, {"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": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "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[43]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "d2554f2002b5fe1e3d2985567a1f130a884b517f3d1f4e8eb7deae5f9e31d40d"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "6c0d6ea3c1f7e13b183019855bee7991e3479c9e2a47d79cd521eef82dfd55f3", "manual_language": "zh"}, "15": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.19"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=15", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=15", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=15", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=15", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=15", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=15", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=15", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=15", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=15", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=15", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=15", "label": "\\dv"}, {"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": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "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[45]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "44ebd298962861385faad1eaa767dcb76bd36f14154b2f9000d9d18f7ef14829"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "6c0d6ea3c1f7e13b183019855bee7991e3479c9e2a47d79cd521eef82dfd55f3", "manual_language": "zh"}, "16": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.15"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=16", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=16", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=16", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=16", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=16", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=16", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=16", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=16", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=16", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=16", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=16", "label": "\\dv"}, {"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-DE", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DE", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493", "language": "en", "original_url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-DE"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DE", "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[47]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "f29a6e62d96e1da7a01d0d7f7a9986829b6d25d9c2598c240b60a7c3ce248fc5"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "6c0d6ea3c1f7e13b183019855bee7991e3479c9e2a47d79cd521eef82dfd55f3", "manual_language": "zh"}, "17": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.11"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=17", "text": "\\dE"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=17", "text": "\\di"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=17", "text": "\\dm"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=17", "text": "\\ds"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=17", "text": "\\dt"}, "modifiers": "S+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=17", "text": "\\dv"}, "modifiers": "S+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=17", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=17", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=17", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=17", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=17", "label": "\\dv"}, {"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-DE", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DE", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b", "language": "en", "original_url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-DE"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[S+] [ pattern ]
\\di[S+] [ pattern ]
\\dm[S+] [ pattern ]
\\ds[S+] [ pattern ]
\\dt[S+] [ pattern ]
\\dv[S+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DE", "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[47]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "48b08fa7b86dfb17b117a1ea9620ef704c92e6b33d07f0be4380e237eca99234"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "S+"}, {"command": "\\di", "modifiers": "S+"}, {"command": "\\dm", "modifiers": "S+"}, {"command": "\\ds", "modifiers": "S+"}, {"command": "\\dt", "modifiers": "S+"}, {"command": "\\dv", "modifiers": "S+"}], "signature": "\\dE[S+] [ pattern ] \\di[S+] [ pattern ] \\dm[S+] [ pattern ] \\ds[S+] [ pattern ] \\dt[S+] [ pattern ] \\dv[S+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "6c0d6ea3c1f7e13b183019855bee7991e3479c9e2a47d79cd521eef82dfd55f3", "manual_language": "zh"}, "18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=18", "text": "\\dE"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=18", "text": "\\di"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=18", "text": "\\dm"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=18", "text": "\\ds"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=18", "text": "\\dt"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=18", "text": "\\dv"}, "modifiers": "Sx+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=18", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=18", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=18", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=18", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=18", "label": "\\dv"}, {"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-DE", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DE", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DE"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[Sx+] [ pattern ]
\\di[Sx+] [ pattern ]
\\dm[Sx+] [ pattern ]
\\ds[Sx+] [ pattern ]
\\dt[Sx+] [ pattern ]
\\dv[Sx+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DE", "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[51]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "c9a9497c344d893994b7c44351a59a4f03422d8064b8b1fecb3444a418225d25"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "25d729c1c83f8c43a17e7dd60f0b8912d473db76af0afbc753d1071fe020c360", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=19", "text": "\\dE"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=19", "text": "\\di"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=19", "text": "\\dm"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=19", "text": "\\ds"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=19", "text": "\\dt"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=19", "text": "\\dv"}, "modifiers": "Sx+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=19", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=19", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=19", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=19", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=19", "label": "\\dv"}, {"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-DE", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DE", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-DE"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[Sx+] [ pattern ]
\\di[Sx+] [ pattern ]
\\dm[Sx+] [ pattern ]
\\ds[Sx+] [ pattern ]
\\dt[Sx+] [ pattern ]
\\dv[Sx+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DE", "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[51]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "ba80e4611df716a52068b61e8996ebc42dceab26323b6cc2023ed52637dafadc"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "25d729c1c83f8c43a17e7dd60f0b8912d473db76af0afbc753d1071fe020c360", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=20", "text": "\\dE"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=20", "text": "\\di"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=20", "text": "\\dm"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=20", "text": "\\ds"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=20", "text": "\\dt"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=20", "text": "\\dv"}, "modifiers": "Sx+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=20", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=20", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=20", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=20", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=20", "label": "\\dv"}, {"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-DE", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DE", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-DE"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[Sx+] [ pattern ]
\\di[Sx+] [ pattern ]
\\dm[Sx+] [ pattern ]
\\ds[Sx+] [ pattern ]
\\dt[Sx+] [ pattern ]
\\dv[Sx+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DE", "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[51]"]}], "language": "zh", "original_text": {"/summary": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/category": "Describe database objects", "/versions/20/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "f61c974854a4476b1314bf9448b26da325700b612a28faa3449fdb63315dd9fb"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "25d729c1c83f8c43a17e7dd60f0b8912d473db76af0afbc753d1071fe020c360", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\dm"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-64-45/?v=18", "text": "\\dE"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-69/?v=18", "text": "\\di"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-6d/?v=18", "text": "\\dm"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-73/?v=18", "text": "\\ds"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-74/?v=18", "text": "\\dt"}, "modifiers": "Sx+"}, {"command": {"url": "/wiki/psql/cmd-64-76/?v=18", "text": "\\dv"}, "modifiers": "Sx+"}], "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": "\\dm", "related": [{"url": "/wiki/psql/cmd-64-45/?v=18", "label": "\\dE"}, {"url": "/wiki/psql/cmd-64-69/?v=18", "label": "\\di"}, {"url": "/wiki/psql/cmd-64-73/?v=18", "label": "\\ds"}, {"url": "/wiki/psql/cmd-64-74/?v=18", "label": "\\dt"}, {"url": "/wiki/psql/cmd-64-76/?v=18", "label": "\\dv"}, {"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-DE", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-DE", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DE"}], "sections": [], "modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "description": ["\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E \u3001 i \u3001 m \u3001 s \u3001 t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c \\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x \uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002"], "manual_html": "
\\dE[Sx+] [ pattern ]
\\di[Sx+] [ pattern ]
\\dm[Sx+] [ pattern ]
\\ds[Sx+] [ pattern ]
\\dt[Sx+] [ pattern ]
\\dv[Sx+] [ pattern ]
\n

\n

\u5728\u8fd9\u7ec4\u547d\u4ee4\u4e2d\uff0c\u5b57\u6bcd E\u3001i\u3001m\u3001s\u3001t \u548c v \u5206\u522b\u8868\u793a\u5916\u90e8\u8868\u3001\u7d22\u5f15\u3001\u7269\u5316\u89c6\u56fe\u3001\u5e8f\u5217\u3001\u8868\u548c\u89c6\u56fe\u3002\u4f60\u53ef\u4ee5\u6309\u4efb\u610f\u987a\u5e8f\u6307\u5b9a\u5176\u4e2d\u4efb\u610f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b57\u6bcd\uff0c\u4ee5\u83b7\u53d6\u8fd9\u4e9b\u7c7b\u578b\u5bf9\u8c61\u7684\u5217\u8868\u3002\u4f8b\u5982\uff0c\\dti \u4f1a\u5217\u51fa\u8868\u548c\u7d22\u5f15\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 x\uff0c\u7ed3\u679c\u4f1a\u4ee5\u6269\u5c55\u6a21\u5f0f\u663e\u793a\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u6bcf\u4e2a\u5bf9\u8c61\u90fd\u4f1a\u8fde\u540c\u5176\u6301\u4e45\u6027\u72b6\u6001\uff08\u6c38\u4e45\u3001\u4e34\u65f6\u6216\u4e0d\u8bb0\u5f55 WAL\uff09\u3001\u78c1\u76d8\u4e0a\u7684\u7269\u7406\u5927\u5c0f\u4ee5\u53ca\u76f8\u5173\u63cf\u8ff0\uff08\u5982\u679c\u6709\uff09\u4e00\u8d77\u5217\u51fa\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u5bf9\u8c61\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u53ea\u663e\u793a\u7528\u6237\u521b\u5efa\u7684\u5bf9\u8c61\uff1b\u63d0\u4f9b\u6a21\u5f0f\u6216 S \u4fee\u9970\u7b26\u53ef\u5305\u62ec\u7cfb\u7edf\u5bf9\u8c61\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-DE", "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[51]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.", "/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/5/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": "c9a9497c344d893994b7c44351a59a4f03422d8064b8b1fecb3444a418225d25"}, "comparison_data": {"modifiers": [{"command": "\\dE", "modifiers": "Sx+"}, {"command": "\\di", "modifiers": "Sx+"}, {"command": "\\dm", "modifiers": "Sx+"}, {"command": "\\ds", "modifiers": "Sx+"}, {"command": "\\dt", "modifiers": "Sx+"}, {"command": "\\dv", "modifiers": "Sx+"}], "signature": "\\dE[Sx+] [ pattern ] \\di[Sx+] [ pattern ] \\dm[Sx+] [ pattern ] \\ds[Sx+] [ pattern ] \\dt[Sx+] [ pattern ] \\dv[Sx+] [ pattern ]", "spellings": ["\\dE", "\\di", "\\dm", "\\ds", "\\dt", "\\dv"], "definition": "In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects."}, "comparison_hash": "25d729c1c83f8c43a17e7dd60f0b8912d473db76af0afbc753d1071fe020c360", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "changed", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1,32 +1,32 @@\n {\n- \"definition\": \"In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\\\dti lists tables and indexes. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.\",\n+ \"definition\": \"In this group of commands, the letters E , i , m , s , t , and v stand for foreign table, index, materialized view, sequence, table, and view, respectively. You can specify any or all of these letters, in any order, to obtain a listing of objects of these types. For example, \\\\dti lists tables and indexes. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, each object is listed with its persistence status (permanent, temporary, or unlogged), physical size on disk, and associated description if any. If pattern is specified, only objects whose names match the pattern are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects.\",\n \"modifiers\": [\n {\n \"command\": \"\\\\dE\",\n- \"modifiers\": \"S+\"\n+ \"modifiers\": \"Sx+\"\n },\n {\n \"command\": \"\\\\di\",\n- \"modifiers\": \"S+\"\n+ \"modifiers\": \"Sx+\"\n },\n {\n \"command\": \"\\\\dm\",\n- \"modifiers\": \"S+\"\n+ \"modifiers\": \"Sx+\"\n },\n {\n \"command\": \"\\\\ds\",\n- \"modifiers\": \"S+\"\n+ \"modifiers\": \"Sx+\"\n },\n {\n \"command\": \"\\\\dt\",\n- \"modifiers\": \"S+\"\n+ \"modifiers\": \"Sx+\"\n },\n {\n \"command\": \"\\\\dv\",\n- \"modifiers\": \"S+\"\n+ \"modifiers\": \"Sx+\"\n }\n ],\n- \"signature\": \"\\\\dE[S+] [ pattern ] \\\\di[S+] [ pattern ] \\\\dm[S+] [ pattern ] \\\\ds[S+] [ pattern ] \\\\dt[S+] [ pattern ] \\\\dv[S+] [ pattern ]\",\n+ \"signature\": \"\\\\dE[Sx+] [ pattern ] \\\\di[Sx+] [ pattern ] \\\\dm[Sx+] [ pattern ] \\\\ds[Sx+] [ pattern ] \\\\dt[Sx+] [ pattern ] \\\\dv[Sx+] [ pattern ]\",\n \"spellings\": [\n \"\\\\dE\",\n \"\\\\di\","}}