Re: PgAdmin3 for Suse AMD64

["Chandra Sekhar Surapaneni" <chandu@xxxxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Hrishikesh Deshmukh
Sent: Thursday, February 09, 2006 12:52 PM
To: pgsql-general@xxxxxxxxxxxxxx
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