How to find list of users in Azure PostgreSQL

In this article, we will see how to find list of users in Azure PostgreSQL. We can get list of users by querying against pg_user view and by expanding Login/Role Groups in pgadmin tool.

Find list of users in Azure PostgreSQL:

1. Find list of users in Azure PostgreSQL by using pg_user:

select usename from pg_user;

How to find list of users in Azure PostgreSQL

2. By expanding Login/Group Roles from pgadmin.