(TIL) PSQL: List Database Users

less than 1 minute read

Within psql, type \du to list all the users for a database and their respective permissions.

> \du
                              List of roles
 Role name  |                   Attributes                   | Member of
------------+------------------------------------------------+-----------
 jbranchaud | Superuser, Create role, Create DB, Replication | {}
 sampleuser | Create DB                                      | {}

Via jbranchaud/til.

Comments