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

From: "Sibte Abbas" <sibtay(at)gmail(dot)com>
To: "Jessica Richard" <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to get a list of members of a postgres group?
Date: 2007-07-05 18:14:49
Message-ID: bd6a35510707051114g2b16a647s9bad6885656da654@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 7/5/07, Jessica Richard <rjessil(at)yahoo(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-07-05 18:17:16 Re: More than one pg_database entry for database
Previous Message Joshua D. Drake 2007-07-05 18:04:24 Re: Other list - or answer?