← flaviocopes.com

How to list all users in PostgreSQL

Published Jan 01 2020

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.



Check out my books

JavaScript Python Golang C PHP Swift HTML CSS React Node.js Svelte Next.js Command Line Express.js SQL

© 2023 Flavio Copes Flavio Copes using Notion to Site Notion to Site. Follow on Twitter

Solopreneur? Wannabe? Adventure awaits