\du

psql Commands

List PostgreSQL users/roles

Examples

Common usage examples

List all users and roles

\du

List with additional info

\du+

Notes

Shows role attributes like superuser, createdb

Related Commands

You might also find these useful

psql createuser