lists all users under groups

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: lists all users under groups
Date: 2006-01-16 19:43:49
Message-ID: 43CBF775.3000600@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2006-01-16 19:50:51 Re: lists all users under groups
Previous Message Tom Lane 2006-01-16 19:06:06 Re: Rule system and unsucessful updates.