\du

Category: Databases & SQL

\du

List database roles and their attributes

Roles are PostgreSQL's combined concept of users and groups. \du shows each role with flags like superuser or login; \du+ adds role memberships. Related: \dp shows table-level privileges.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.