2010/2/19 Jignesh Shah <jignesh.shah1980@xxxxxxxxx>: > 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? I think you're looking for: SELECT rolname from pg_authid a INNER JOIN pg_auth_members m ON m.member=a.oid WHERE m.roleid=(SELECT oid FROM pg_authid WHERE rolname='database-users') or something similar to that. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general