Postgres Pro
Downloads
Home   >   mailing lists

Re: how to get a list of members of a postgres group? - Mailing list pgsql-admin

From Sibte Abbas
Subject Re: how to get a list of members of a postgres group?
Date
Msg-id bd6a35510707051114g2b16a647s9bad6885656da654@mail.gmail.com
Whole thread Raw
In response to how to get a list of members of a postgres group?  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Other list - or answer?
Next
From: Tom Lane
Date:
Subject: Re: More than one pg_database entry for database