How to List All Users in PostgreSQL

Discover how to retrieve a comprehensive list of all users existing in a PostgreSQL database, along with their permissions.

To achieve this, follow these steps:

  1. Open the psql interface.
  2. Execute the \du command.

Upon executing the command, you will receive a detailed overview of all users in the system. This includes their role attributes and the associated role groups they belong to.

Image: List all users in PostgreSQL

Tags: PostgreSQL, user management, permissions, role groups