Re: PgAdmin3 for Suse AMD64
| От | Chandra Sekhar Surapaneni |
|---|---|
| Тема | Re: PgAdmin3 for Suse AMD64 |
| Дата | |
| Msg-id | 0F7F9A82BB0DBB4396A9F8386D0E0612A25505@pos-exch1.corp.positivenetworks.net обсуждение исходный текст |
| Ответ на | PgAdmin3 for Suse AMD64 (Hrishikesh Deshmukh <hdeshmuk@gmail.com>) |
| Список | pgsql-general |
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
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
В списке pgsql-general по дате отправления: