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;
2. By expanding Login/Group Roles from pgadmin.