Thread: how to get a list of members of a postgres group?

Creatred a group, added members to the group, what command to use to check the current members in the group?  thanks.

---

We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.

On 7/5/07, Jessica Richard <rjessil@yahoo.com> wrote:
> Creatred a group, added members to the group, what command to use to check
> the current members in the group?  thanks.
>
>

You can query group related information from the pg_group view. The
'grolist' parameter would contain an array of the sysid's of all its
members.

regards,
--
Sibte Abbas
EnterpriseDB http://www.enterprisedb.com