Skip to content

How to list all users in PostgreSQL

Find out how to get a list of all the users present in a PostgreSQL database, and their permissions

From the psql interface, run the \du command:

List all users in PostgreSQL

This will give you the list of all users in the system, plus their role attributes and the list of role groups they are member of.

I wrote 17 books to help you become a better developer, download them all at $0 cost by joining my newsletter

JOIN MY CODING BOOTCAMP, an amazing cohort course that will be a huge step up in your coding career - covering React, Next.js - next edition February 2025

Bootcamp 2025

Join the waiting list