Re: pg_group members - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: pg_group members
Date
Msg-id 200206282327.g5SNRdT14609@candle.pha.pa.us
Whole thread Raw
In response to pg_group members  (Kelly <quadratini@sni.ph>)
List pgsql-sql
Kelly wrote:
> 
> How do I list all members of a certain pg_group?
> Any help would be greatly appreciated.

Uh, we should have an easy way to do that, but we don't.  You have to
take the userid's from pg_group and look them up in pg_user.

We do have a TODO item:
* Allow easy display of usernames in a group

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 




pgsql-sql by date:

Previous
From: Kelly
Date:
Subject: pg_group members
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: creating functional index over multiple columns