Editing List users and roles: \du

List users and [[PostgreSQL: Role|Roles]]
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 <code>[[\dg]]</code>.) 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 <code>\du+</code> is used, additional information is shown about each role; currently this adds the comment for each role.


* <code> \du</code>
* <code>[[\du+]]</code>

List [[roles]] using <code>\du</code> 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, [[PostgreSQL replication|Replication]], [[Bypass RLS]] | {}

* <code> SELECT * FROM [[pg_roles]]; </code>
* <code> SELECT rolname FROM [[pg_roles]]; </code>


==Related terms==
* <code>[[\l]]</code> or <code>[[\list]]</code> to [[list databases]]
* Postgres: <code>[[create role]]</code>
* <code>[[create user]]</code>
* <code>[[.psqlrc]]</code>
* <code>[[show users]]</code>
* [[RDS_SUPERUSER]], [[rds_master]], [[rdsadmin]]
* <code>[[\dt]]</code>
* <code>[[\ddp]]</code> lists default access privilege settings
* [[ALTER USER]] YOUR_USER WITH PASSWORD 'your_new_password';

== See also ==
* {{Role}}
* {{GRANT}}
* {{psql}}

[[Category: PostgreSQL]]
[[Category: SQL]]