PgAdmin3 for Suse AMD64

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

________________________________

From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Hrishikesh
Deshmukh
Sent: Thursday, February 09, 2006 12:52 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PgAdmin3 for Suse AMD64

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