{"kind": "psql", "major": "18", "item": {"slug": "cmd-6c", "name": "\\l", "name_zh": "", "category": "\u63cf\u8ff0\u6570\u636e\u5e93\u5bf9\u8c61", "summary": "\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002", "aliases": ["\\l", "\\l+", "\\lx", "\\lx+"], "content_hash": "8208aa719342a494271cae6a52941bc5fced22fdeffca517276821747b449f72", "versions": {"10": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 10.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=10", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=10", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=10", "label": "\\list"}, {"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": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09"], "manual_html": "
\\l[+] \u6216 \\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09

\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[115]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[114]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)", "/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/1/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": "408617f9e3f5e721b1ccd6ca6a83f8b68ec3c22322ee702e495cb82679703505"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)"}, "comparison_hash": "2fef12704a55a1f97d0e0947d2344cafb3a026754a0b375529a594f8f3537f77", "manual_language": "zh"}, "11": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 11.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=11", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=11", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=11", "label": "\\list"}, {"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": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09"], "manual_html": "
\\l[+] \u6216 \\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09

\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[117]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[116]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)", "/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/1/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": "ea7c0672fbf133e2eb4d623c22d14427462cfd1ef7ad16b2e5822d0f1a7d12e4"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)"}, "comparison_hash": "2fef12704a55a1f97d0e0947d2344cafb3a026754a0b375529a594f8f3537f77", "manual_language": "zh"}, "12": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 12.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=12", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=12", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=12", "label": "\\list"}, {"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": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09"], "manual_html": "
\\l[+] \u6216 \\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09

\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[119]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[118]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)", "/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/1/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": "83c81bb8751a445b537fb5408142ed96cd5731401d77794bb7089c1fc5c0ece4"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)"}, "comparison_hash": "2fef12704a55a1f97d0e0947d2344cafb3a026754a0b375529a594f8f3537f77", "manual_language": "zh"}, "13": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 13.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=13", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=13", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=13", "label": "\\list"}, {"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": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0 + \uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09"], "manual_html": "
\\l[+] \u6216 \\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u62e5\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u5339\u914d\u8be5\u6a21\u5f0f\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u9644\u52a0+\uff0c\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\uff08\u5927\u5c0f\u4fe1\u606f\u53ea\u5bf9\u5f53\u524d\u7528\u6237\u80fd\u591f\u8fde\u63a5\u7684\u6570\u636e\u5e93\u53ef\u7528\u3002\uff09

\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[127]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[126]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)", "/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/1/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": "044ed668ea0936790bda58c869c1fe81666ad26dcb93b563e5ca804bdbddc43d"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. (Size information is only available for databases that the current user can connect to.)"}, "comparison_hash": "2fef12704a55a1f97d0e0947d2344cafb3a026754a0b375529a594f8f3537f77", "manual_language": "zh"}, "14": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.24"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=14", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=14", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=14", "label": "\\list"}, {"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": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[+]\u6216\\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\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[129]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[128]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "2446bc6f48a18dc9c49a9be78099054f857bb4eb1bc75da6b619baf620cc4e93"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "91f23d5520c9e3323102e5241df568ee2158014db29fb08007cc302d2b227a30", "manual_language": "zh"}, "15": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.19"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=15", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=15", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=15", "label": "\\list"}, {"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": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[+]\u6216\\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\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[133]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[132]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "cb54331ce60e9d41de12ce1242bef7158b0fdb99dcd1e124e15008c1c8679117"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "91f23d5520c9e3323102e5241df568ee2158014db29fb08007cc302d2b227a30", "manual_language": "zh"}, "16": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.15"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=16", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=16", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=16", "label": "\\list"}, {"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-LIST", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-LIST", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493", "language": "en", "original_url": "/docs/16/app-psql.html#APP-PSQL-META-COMMAND-LIST"}], "sections": [], "modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[+]\u6216\\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-LIST", "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[137]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[136]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "99217b2d71ab49905becc28e0d76293a92138ccd78359efc82d8cf3bf0c70508"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "91f23d5520c9e3323102e5241df568ee2158014db29fb08007cc302d2b227a30", "manual_language": "zh"}, "17": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.11"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=17", "text": "\\l"}, "modifiers": "+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=17", "text": "\\list"}, "modifiers": "+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=17", "label": "\\list"}, {"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-LIST", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-LIST", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b", "language": "en", "original_url": "/docs/17/app-psql.html#APP-PSQL-META-COMMAND-LIST"}], "sections": [], "modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 + \uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[+]\u6216\\list[+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\u3002\u5982\u679c\u5728\u547d\u4ee4\u540d\u540e\u8ffd\u52a0 +\uff0c\u5219\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-LIST", "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[137]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dt[136]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "69330e496a5ae335518ab4004aa5e1736ab27ff98e7ee051c725538570854349"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "+"}, {"command": "\\list", "modifiers": "+"}], "signature": "\\l[+] or \\list[+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "91f23d5520c9e3323102e5241df568ee2158014db29fb08007cc302d2b227a30", "manual_language": "zh"}, "18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=18", "text": "\\l"}, "modifiers": "x+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=18", "text": "\\list"}, "modifiers": "x+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=18", "label": "\\list"}, {"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-LIST", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-LIST", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-LIST"}], "sections": [], "modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[x+]\u6216\\list[x+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-LIST", "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[141]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dt[140]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "a7cf0cc33f4096590c0d1c1676e905a9cb2184d1c6244214c1b1ef0dd7f768dc"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "9bee9623a3d7894410dd483338598675140e1aac96df705a2bb2aa1948963881", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=19", "text": "\\l"}, "modifiers": "x+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=19", "text": "\\list"}, "modifiers": "x+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=19", "label": "\\list"}, {"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-LIST", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-LIST", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMAND-LIST"}], "sections": [], "modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[x+]\u6216\\list[x+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-LIST", "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[141]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dt[140]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "717e8f3a2b5f99a70ecfe2658b28036de9a82489bd35c65da2946e7b45f12f43"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "9bee9623a3d7894410dd483338598675140e1aac96df705a2bb2aa1948963881", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=20", "text": "\\l"}, "modifiers": "x+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=20", "text": "\\list"}, "modifiers": "x+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=20", "label": "\\list"}, {"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-LIST", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-LIST", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMAND-LIST"}], "sections": [], "modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[x+]\u6216\\list[x+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-LIST", "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[141]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dt[140]"]}], "language": "zh", "original_text": {"/summary": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/category": "Describe database objects", "/versions/20/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "f4f84896e0cd3f5301750832dcef0e89c23219c16e250a35447425956e990d6c"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "9bee9623a3d7894410dd483338598675140e1aac96df705a2bb2aa1948963881", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\l"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-6c/?v=18", "text": "\\l"}, "modifiers": "x+"}, {"command": {"url": "/wiki/psql/cmd-6c-69-73-74/?v=18", "text": "\\list"}, "modifiers": "x+"}], "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": "\\l", "related": [{"url": "/wiki/psql/cmd-6c-69-73-74/?v=18", "label": "\\list"}, {"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-LIST", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMAND-LIST", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMAND-LIST"}], "sections": [], "modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "description": ["\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern \uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002"], "manual_html": "
\\l[x+]\u6216\\list[x+] [ pattern ]
\n

\n

\u5217\u51fa\u670d\u52a1\u5668\u4e2d\u7684\u6570\u636e\u5e93\uff0c\u5e76\u663e\u793a\u5176\u540d\u79f0\u3001\u6240\u6709\u8005\u3001\u5b57\u7b26\u96c6\u7f16\u7801\u548c\u8bbf\u95ee\u6743\u9650\u3002\u5982\u679c\u6307\u5b9a\u4e86 pattern\uff0c\u5219\u53ea\u5217\u51fa\u540d\u79f0\u4e0e\u6a21\u5f0f\u5339\u914d\u7684\u6570\u636e\u5e93\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\u8fd8\u4f1a\u663e\u793a\u6570\u636e\u5e93\u5927\u5c0f\u3001\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u63cf\u8ff0\u3002\u5f53\u524d\u7528\u6237\u5bf9\u5176\u62e5\u6709 CONNECT \u6743\u9650\u7684\u6570\u636e\u5e93\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\uff1b\u5982\u679c\u5f53\u524d\u7528\u6237\u662f\u8d85\u7ea7\u7528\u6237\u6216\u5177\u6709 pg_read_all_stats \u89d2\u8272\u7684\u6743\u9650\uff0c\u4e5f\u53ef\u4ee5\u663e\u793a\u5927\u5c0f\u4fe1\u606f\u3002

\n

\n
", "manual_path": "app-psql.html#APP-PSQL-META-COMMAND-LIST", "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[141]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dt[140]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.", "/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/1/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": "a7cf0cc33f4096590c0d1c1676e905a9cb2184d1c6244214c1b1ef0dd7f768dc"}, "comparison_data": {"modifiers": [{"command": "\\l", "modifiers": "x+"}, {"command": "\\list", "modifiers": "x+"}], "signature": "\\l[x+] or \\list[x+] [ pattern ]", "spellings": ["\\l", "\\list"], "definition": "List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role."}, "comparison_hash": "9bee9623a3d7894410dd483338598675140e1aac96df705a2bb2aa1948963881", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "changed", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1,16 +1,16 @@\n {\n- \"definition\": \"List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.\",\n+ \"definition\": \"List the databases in the server and show their names, owners, character set encodings, and access privileges. If pattern is specified, only databases whose names match the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, database sizes, default tablespaces, and descriptions are also displayed. Size information is available for databases on which the current user has CONNECT privilege, or if the current user is a superuser or has privileges of the pg_read_all_stats role.\",\n \"modifiers\": [\n {\n \"command\": \"\\\\l\",\n- \"modifiers\": \"+\"\n+ \"modifiers\": \"x+\"\n },\n {\n \"command\": \"\\\\list\",\n- \"modifiers\": \"+\"\n+ \"modifiers\": \"x+\"\n }\n ],\n- \"signature\": \"\\\\l[+] or \\\\list[+] [ pattern ]\",\n+ \"signature\": \"\\\\l[x+] or \\\\list[x+] [ pattern ]\",\n \"spellings\": [\n \"\\\\l\",\n \"\\\\list\""}}