Postgres Pro
Downloads
Home   >   mailing lists

lists all users under groups - Mailing list pgsql-general

From Emi Lu
Subject lists all users under groups
Date
Msg-id 43CBF775.3000600@encs.concordia.ca
Whole thread Raw
Responses Re: lists all users under groups
List pgsql-general
Tree view 
Greetings,

May I ask is there a simple way like \dg+ to get all users' names under
all groups please? If no, which sys tables should I use to get it?

I am expecting something like :

Group name   | Users
----------------------------------
 g1  |      u1, u2, u3
 g2  |      u1
 g3  |      u6

Thanks a lot!
Emi

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rule system and unsucessful updates.
Next
From: Emi Lu
Date:
Subject: Re: lists all users under groups