{"Entry":{"collection":"psql","key":"cmd-6c-69-73-74","name":"\\list","aliases":["\\list","\\list+","\\listx","\\listx+"],"metadata":{"aliases":["\\list","\\list+","\\listx","\\listx+"],"category":"Describe database objects","content_hash":"3b77ce61021ba94a8f67099178c406f8646c865dc32eb60121da8fc045633a0b","derived_content_hash":"29e499bff7354b279ab0a5e3bbfc45fb0ccccf23c1c3b14833648aff8fc74973","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:45.094633+08:00","name":"\\list","name_zh":"","slug":"cmd-6c-69-73-74","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."}},"Definition":{"Collection":"psql","Key":"cmd-6c-69-73-74","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-6c-69-73-74","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\list","comparison_data":{"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.","modifiers":[{"command":"\\l","modifiers":"x+"},{"command":"\\list","modifiers":"x+"}],"signature":"\\l[x+] or \\list[x+] [ pattern ]","spellings":["\\l","\\list"]},"comparison_hash":"9bee9623a3d7894410dd483338598675140e1aac96df705a2bb2aa1948963881","description":["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."],"description_zh":"列出服务器中的数据库，并显示其名称、所有者、字符集编码和访问权限。如果指定了 pattern ，则只列出名称与模式匹配的数据库。如果在命令名后追加 x ，结果会以扩展模式显示。如果在命令名后追加 + ，则还会显示数据库大小、默认表空间和描述。当前用户对其拥有 CONNECT 权限的数据库可以显示大小信息；如果当前用户是超级用户或具有 pg_read_all_stats 角色的权限，也可以显示大小信息。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        列出服务器中的数据库，并显示其名称、所有者、字符集编码和访问权限。如果指定了 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e，则只列出名称与模式匹配的数据库。如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。如果在命令名后追加 \u003ccode class=\"literal\"\u003e+\u003c/code\u003e，则还会显示数据库大小、默认表空间和描述。当前用户对其拥有 \u003ccode class=\"literal\"\u003eCONNECT\u003c/code\u003e 权限的数据库可以显示大小信息；如果当前用户是超级用户或具有 \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e 角色的权限，也可以显示大小信息。\n        \u003c/p\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\list"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\list"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LIST\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\l[x+]\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\list[x+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        List the databases in the server and show their names, owners,\n        character set encodings, and access privileges.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified,\n        only databases whose names match the pattern are listed.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, database\n        sizes, default tablespaces, and descriptions are also displayed.\n        Size information is available for databases on which the current user has\n        \u003ccode class=\"literal\"\u003eCONNECT\u003c/code\u003e privilege, or if the current user is a superuser\n        or has privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LIST","modifiers":[{"command":"\\l","modifiers":"x+"},{"command":"\\list","modifiers":"x+"}],"related":[{"label":"\\l","url":"/wiki/psql/cmd-6c/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"\\l","url":"/wiki/psql/cmd-6c/?v=18"},{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\l[x+] or \\list[x+] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-LIST","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-LIST"}],"spellings":["\\l","\\list"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\l","url":"/wiki/psql/cmd-6c/?v=18"},"modifiers":"x+"},{"command":{"text":"\\list","url":"/wiki/psql/cmd-6c-69-73-74/?v=18"},"modifiers":"x+"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\l","url":"/wiki/psql/cmd-6c/?v=18"},"modifiers":"x+"},{"command":{"text":"\\list","url":"/wiki/psql/cmd-6c-69-73-74/?v=18"},"modifiers":"x+"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LIST","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-LIST","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-LIST"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-6c-69-73-74","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\list","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.","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LIST\"\u003e\u003cspan\u003e\u003ccode\u003e\\l[x+]\u003c/code\u003e or \u003ccode\u003e\\list[x+] [ \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003e\u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        List the databases in the server and show their names, owners,\n        character set encodings, and access privileges.\n        If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified,\n        only databases whose names match the pattern are listed.\n        If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode\u003e+\u003c/code\u003e is appended to the command name, database\n        sizes, default tablespaces, and descriptions are also displayed.\n        Size information is available for databases on which the current user has\n        \u003ccode\u003eCONNECT\u003c/code\u003e privilege, or if the current user is a superuser\n        or has privileges of the \u003ccode\u003epg_read_all_stats\u003c/code\u003e role.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"d4e90cad0f5507c92d22b8985e48c413dbc82bf858dcae2c7832fef9afb3b575","Payload":{"description":["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."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-LIST\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\l[x+]\u003c/code\u003e or \u003ccode class=\"literal\"\u003e\\list[x+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        List the databases in the server and show their names, owners,\n        character set encodings, and access privileges.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified,\n        only databases whose names match the pattern are listed.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, database\n        sizes, default tablespaces, and descriptions are also displayed.\n        Size information is available for databases on which the current user has\n        \u003ccode class=\"literal\"\u003eCONNECT\u003c/code\u003e privilege, or if the current user is a superuser\n        or has privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"\\l","url":"/wiki/psql/cmd-6c/?v=18"},{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\l","url":"/wiki/psql/cmd-6c/?v=18"},"modifiers":"x+"},{"command":{"text":"\\list","url":"/wiki/psql/cmd-6c-69-73-74/?v=18"},"modifiers":"x+"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\l","Signature":"\\l[x+] or \\list[x+] [ pattern ]","Modifiers":[{"command":"\\l","modifiers":"x+"},{"command":"\\list","modifiers":"x+"}]},{"Version":"18","Ordinal":1,"Command":"\\list","Signature":"\\l[x+] or \\list[x+] [ pattern ]","Modifiers":[{"command":"\\l","modifiers":"x+"},{"command":"\\list","modifiers":"x+"}]}],"SQLState":null,"Evidence":null}