List users and roles: \du

From wikieduonline
Revision as of 11:54, 16 December 2022 by Ant (talk | contribs) (→‎Related terms)
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: