Re: [GENERAL] PgAdmin3 for Suse AMD64

[Chandra Sekhar Surapaneni]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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