> Given a username, how do I find out which groups that user is a member
> of? I'm sure I'm missing something obvious.
IMO, there is no straight method, but you can get it using a plpgsql
function. But the list of users belonging to a group can be found in
pg_group table. The userids are stored in an array.
regards,
bhuvaneswaran
