select groname, grosysid, usename from pg_user right outer join pg_group on usesysid = any(grolist);
This should do the job for 1).
- Chandra Sekhar Surapaneni
Dear All,
I have two questions:
1) One can used select * from pg_group to get list of groups BUT how does one get group membership say for this example find users who are under the group sales?!
booktown=# SELECT * FROM pg_group;
groname | grosysid | grolist
------------+----------+-------------
sales | 1 | {7017,7016}
accounting | 2 |
marketing | 3 |
(3 rows)
2) Where can i find Pgadmin3 rpms for Suse 9.3 for AMD64 Opterons (dual core)?
Thank you
Hrishi