How to get the users name from users group? - Mailing list pgsql-general

From Jignesh Shah
Subject How to get the users name from users group?
Date
Msg-id c11950271002190106n11de9142u113edb45fc1ada4a@mail.gmail.com
Whole thread Raw
Responses Re: How to get the users name from users group?  (Magnus Hagander <magnus@hagander.net>)
List 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Getting number of affected row after performing update
Next
From: Pavel Stehule
Date:
Subject: Re: PERFORM not working properly, please help..