Postgresql 中文操作指南
54.20. pg_roles #
视图 pg_roles 提供用于访问有关数据库角色的信息。这只是 pg_authid 的一个公开可读视图，它将密码字段置空。
The view pg_roles provides access to information about database roles. This is simply a publicly readable view of pg_authid that blanks out the password field.
Table 54.20. pg_roles Columns
Table 54.20. pg_roles Columns
Column Type Description |
rolname name Role name |
rolsuper bool Role has superuser privileges |
rolinherit bool Role automatically inherits privileges of roles it is a member of |
rolcreaterole bool Role can create more roles |
rolcreatedb bool Role can create databases |
rolcanlogin bool Role can log in. That is, this role can be given as the initial session authorization identifier |
rolreplication bool Role is a replication role. A replication role can initiate replication connections and create and drop replication slots. |
rolconnlimit int4 For roles that can log in, this sets maximum number of concurrent connections this role can make. -1 means no limit. |
rolpassword text Not the password (always reads as **) |
rolvaliduntil timestamptz Password expiry time (only used for password authentication); null if no expiration |
rolbypassrls bool Role bypasses every row-level security policy, see Section 5.8 for more information. |
rolconfig text[] Role-specific defaults for run-time configuration variables |
oid oid (references pg_authid.oid) ID of role |