CODEWITHSUNDEEP
postgresqllistroles
Hashka
Hashka

Reputation: 445

How to ONLY list the Group Roles with PostgreSQL?

I'm trying to list the group roles in PostgreSQL. Not Users, Not Users + Group Roles, Only Group Roles.

As I know,

This is how to list only Users :

SELECT * FROM pg_shadow;

or

SELECT * FROM pg_user;

& here's how to list Users + Group Roles :

SELECT * FROM pg_authid;

or

SELECT * FROM pg_roles;

SO NOW, I just want to list ONLY Group Roles.

Hope you can help me...

Upvotes: 2

Views: 2759

Answers (1)

Hashka
Hashka

Reputation: 445

Thanks to @memosdp, the following answer is correct :

SELECT * FROM pg_group;

Upvotes: 4

Related Questions