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

Поиск
Список
Период
Сортировка
Искать

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

От:
Jessica Richard <rjessil@yahoo.com>
Дата:
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.

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

От:
"Sibte Abbas" <sibtay@gmail.com>
Дата:
On 7/5/07, Jessica Richard  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
FAQ