Re: [pgadmin-support] feature request - show role members

2012-03-02 Thread Bartosz Dmytrak
Thanks for Your time :) hope this will help devs and admins Regards, Bartek 2012/3/2 Guillaume Lelarge > On Thu, 2012-03-01 at 08:06 -0600, Mike Blackwell wrote: > > > > On Wed, Feb 29, 2012 at 16:42, Guillaume Lelarge > > wrote: > > > > I understand, but we cannot put every way of vi

Re: [pgadmin-support] feature request - show role members

2012-03-02 Thread Guillaume Lelarge
On Thu, 2012-03-01 at 08:06 -0600, Mike Blackwell wrote: > > On Wed, Feb 29, 2012 at 16:42, Guillaume Lelarge > wrote: > > I understand, but we cannot put every way of visualizing a > database in > pgAdmin. This tool also needs to be simple to use, and having >

Re: [pgadmin-support] feature request - show role members

2012-02-29 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 20:53 +0100, Bartosz Dmytrak wrote: > 2012/2/28 Guillaume Lelarge > On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > > Hi, > > I would like to see who is member of selected role, > somewhere in group role > > form. Hope this

Re: [pgadmin-support] feature request - show role members

2012-02-28 Thread Bartosz Dmytrak
2012/2/28 Guillaume Lelarge > On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > > Hi, > > I would like to see who is member of selected role, somewhere in group > role > > form. Hope this will help to administrate multiuser environments. > > > > This feature is covered by query: > > SEL

Re: [pgadmin-support] feature request - show role members

2012-02-28 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > Hi, > I would like to see who is member of selected role, somewhere in group role > form. Hope this will help to administrate multiuser environments. > > This feature is covered by query: > SELECT p.rolname, m.rolname as member, g.rolname

[pgadmin-support] feature request - show role members

2012-02-28 Thread Bartosz Dmytrak
Hi, I would like to see who is member of selected role, somewhere in group role form. Hope this will help to administrate multiuser environments. This feature is covered by query: SELECT p.rolname, m.rolname as member, g.rolname as grantor FROM pg_authid p INNER JOIN pg_auth_members am ON (p.oid