How can i list the users of a group?
Thanks.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> writes:
>> ... However, the complementary process, determining all the
>> users in group administrators, isn't so clean.
Tom> Doesn't select grolist from pg_group where groname =
Tom> 'adm
Raj Mathur <[EMAIL PROTECTED]> writes:
> ... However, the complementary process, determining
> all the users in group administrators, isn't so clean.
Doesn't
select grolist from pg_group where groname = 'administrators'
do it for you? I suppose you might want the thing to map sysids
back
Hi,
Using PostgreSQL 7.2.3 on a Linux box and facing some minor issues
with determining which groups users belong to.
I have created a PgSQL group called `administrators'. Now when I need
to check whether user X is a member of that group, I use the
contrib/array_iterator operator to do something
