How to get the users name from users group?

From: Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get the users name from users group?
Date: 2010-02-19 09:06:44
Message-ID: c11950271002190106n11de9142u113edb45fc1ada4a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I have created role "database-users" and inserted some of users inside it.
Could you tell me which query to use for listing out those users name? I
went through pg_users, pg_group but no luck.

CREATE ROLE database-users
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

CREATE ROLE "dbuser1" LOGIN
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
GRANT database-users TO "dbuser1";

CREATE ROLE "dbuser2" LOGIN
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
GRANT database-users TO "dbuser2";

How to query database-users to list the dbuser1 and dbuser2?

Thanks in advance,
Jack

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wilczarz1 2010-02-19 09:54:43 Re: PERFORM not working properly, please help..
Previous Message Richard Huxton 2010-02-19 08:43:43 Re: Not able to access schema functions and table...