deeejay icon

psql - List all groups and its users

deeejay | PRO | 06/05/14 09:34:38 PM UTC | 0 ⭐ | 431 👁️ | Never ⏰ | []
PostgreSQL |

80 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
SELECT groname, usename 
FROM pg_group,pg_user 
WHERE usesysid = any(grolist);

Comments