List users and roles: \du

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

• https://www.postgresql.org/docs/current/app-psql.html

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.

• \du
• \du+

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 | {}

• SELECT * FROM pg_roles;
• SELECT rolname FROM pg_roles;

Related terms

• \l or \list to list databases
• Postgres: create role
• create user
• .psqlrc
• show users
• rds_superuser, rds_master, rdsadmin
• \dt list tables
• \ddp lists default access privilege settings
• \dn
• ALTER USER YOUR_USER WITH PASSWORD 'your_new_password';
• SELECT pg_database_size('your_db_name');

GRANT "your-defined_role" TO "your_username";

See also

• CREATE USER, List users \du, \du+
• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE
• PostgreSQL: psql, .psqlrc, .pgpass, $HOME/.pg service.conf, -U, -W, -d, meta-commands: \du, \dg, \ddp, \dp, \list, \dn, \dt, \c, \l, \di, \q, show users, show, su - postgres, psql -c, \?, \connect, --version, --help, PL/pgSQL