On Wed, Sep 1, 2010 at 11:32 AM, Thom Brown <thom(at)linux(dot)com> wrote:
> Yes, I had discovered this previously but obviously I've got a memory
> leak. Actually, doesn't this apply to roles too?
Yeah, pg_shadow is just a view on top of pg_authid, declared as:
SELECT ...
FROM pg_authid
WHERE pg_authid.rolcanlogin;
So I think either query would work, with pg_shadow only showing you
roles which have login enabled.
Josh