\dg

说明

列出数据库角色。（由于 “ 用户 ” 和 “ 组 ” 的概念已经统一为 “ 角色 ” ，此命令现在等同于 \du 。）默认情况下，只显示用户创建的角色；提供 S 修饰符可包括系统角色。如果指定了 pattern ，则只列出名称与模式匹配的角色。如果在命令名后追加 x ，结果会以扩展模式显示。如果在命令名后追加 + ，则会显示每个角色的附加信息；目前这会增加每个角色的注释。

客户端

psql 18.6

区分大小写的写法

\dg

用法

\dg[Sx+] [ pattern ]

相关条目

• psql 命令行选项及完整手册

文档与源码

• 18.6 English manual · app-psql.html

版本比较

PostgreSQL 17 → 18: 属性变化。

以下差异保留原始字段名与英文源描述。

--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,12 +1,12 @@
 {
-  "definition": "Lists database roles. (Since the concepts of “ users ” and “ groups ” have been unified into “ roles ” , this command is now equivalent to \\du .) By default, only user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only those roles whose names match the pattern are listed. If the form \\dg+ is used, additional information is shown about each role; currently this adds the comment for each role.",
+  "definition": "Lists database roles. (Since the concepts of “ users ” and “ groups ” have been unified into “ roles ” , this command is now equivalent to \\du .) By default, only user-created roles are shown; supply the S modifier to include system roles. If pattern is specified, only those roles 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, additional information is shown about each role; currently this adds the comment for each role.",
   "modifiers": [
     {
       "command": "\\dg",
-      "modifiers": "S+"
+      "modifiers": "Sx+"
     }
   ],
-  "signature": "\\dg[S+] [ pattern ]",
+  "signature": "\\dg[Sx+] [ pattern ]",
   "spellings": [
     "\\dg"
   ]

比较已记录的接口与属性，排除来源指纹和构建元数据。某个样本中没有记录，不能据此判断实际引入或移除的版本。

相关条目

• \d
• \dA
• \dAc
• \dAf
• \dAo
• \dAp
• \dC
• \dD
• \dE
• \dF
• \dFd
• \dFp