List users and roles: \du

From wikieduonline
Revision as of 17:48, 8 January 2024 by Welcome (talk | contribs) (→‎See also)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

List users and Roles (Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.) )

Lists database roles. (Since the concepts of “users” and “groups” have been unified into “roles”, this command is now equivalent to \dg.) 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 \du+ is used, additional information is shown about each role; currently this adds the comment for each role.


List roles using \du command:

Default PostgreSQL 12 in Ubuntu 20.04

postgres=# \du
                                   List of roles
 Role name |                         Attributes                         | Member of
-----------+------------------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}


postgres=# \du
                                      List of roles
   Role name    |                         Attributes                         | Member of
----------------+------------------------------------------------------------+-----------
 YOUR_USER      | Create DB                                                  | {}
 YOUR_USER2     | Cannot login                                               | {}
 YOUR_USER3     |                                                             | {}
 postgres       | Superuser, Create role, Create DB, Replication, Bypass RLS | {}


Related terms

GRANT "your-defined_role" TO "your_username";

See also

Advertising: