\list

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.

当前阅读 PG 18·选择有来源记录的版本

10 11 12 13 14 15 16 17 18 19 20

此版本暂无所选语言的定义，以下显示原始英文内容。

Client: psql 18.6
Case-sensitive spelling: \list
command: \list
manual path: app-psql.html#APP-PSQL-META-COMMAND-LIST
modifiers: map[command:\l modifiers:x+], map[command:\list modifiers:x+]
signature: \l[x+] or \list[x+] [ pattern ]
spellings: \l, \list

版本定义 PG 18

\l[x+] or \list[x+] [ pattern ]: 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.

精确保留大小写的命令写法

\l
\list

Spellings in this manual definition

Command	Documented suffix modifiers
\l	x+
\list	x+

比较版本

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8