[GENERAL] How to get the users name from users group?

2010-02-19 Thread Jignesh Shah
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

Re: [GENERAL] How to get the users name from users group?

2010-02-19 Thread Magnus Hagander
2010/2/19 Jignesh Shah jignesh.shah1...@gmail.com: 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  

Re: [GENERAL] How to get the users name from users group?

2010-02-19 Thread Jignesh Shah
Exactly the same! Thanks a ton. On Fri, Feb 19, 2010 at 3:58 PM, Magnus Hagander mag...@hagander.netwrote: 2010/2/19 Jignesh Shah jignesh.shah1...@gmail.com: Hello All, I have created role database-users and inserted some of users inside it. Could you tell me which query to use for