Find if a user belongs to any groups
Post date: Nov 01, 2014 2:51:44 PM
sachi=# select usesysid, usename, COALESCE(groname,'default') from pg_user u left join pg_group g on ','||array_to_string(grolist,',')||',' like '%,'||cast(usesysid as varchar(10))||',%' where usename='sachi' order by 2,1;
usesysid | usename | coalesce
----------+---------+----------
16994 | sachi | admin
(1 row)
sachi=#