Re: Users and groups - Mailing list pgsql-admin

From Tom Lane
Subject Re: Users and groups
Date
Msg-id 3938.1045196214@sss.pgh.pa.us
Whole thread Raw
In response to Users and groups  (Raj Mathur <raju@linux-delhi.org>)
Responses Re: Users and groups  (Raj Mathur <raju@linux-delhi.org>)
List pgsql-admin
Raj Mathur <raju@linux-delhi.org> 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 to usernames ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Raj Mathur
Date:
Subject: Users and groups
Next
From: Thierry Missimilly
Date:
Subject: How to get Postgres in ODBC