{"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","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":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","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."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\list"}],"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\n\u003cp\u003eList the databases in the server and show their names, owners, character set encodings, and access privileges. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only databases whose names match the pattern are listed. If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003eCONNECT\u003c/code\u003e privilege, or if the current user is a superuser or has privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role.\u003c/p\u003e\n\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"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"\\l[x+] or \\list[x+] [ pattern ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-LIST","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","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"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-LIST","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-LIST","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","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\n\u003cp\u003eList the databases in the server and show their names, owners, character set encodings, and access privileges. If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only databases whose names match the pattern are listed. If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode\u003e+\u003c/code\u003e 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 \u003ccode\u003eCONNECT\u003c/code\u003e privilege, or if the current user is a superuser or has privileges of the \u003ccode\u003epg_read_all_stats\u003c/code\u003e role.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"b6b51098dd1977a89d0823279bd9527e251755ed5997197f16496e2fd9f806eb","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\n\u003cp\u003eList the databases in the server and show their names, owners, character set encodings, and access privileges. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only databases whose names match the pattern are listed. If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003eCONNECT\u003c/code\u003e privilege, or if the current user is a superuser or has privileges of the \u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e role.\u003c/p\u003e\n\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":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"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}