deeejay

psql - List all groups and its users

Jun 5th, 2014
475
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT groname, usename
  2. FROM pg_group,pg_user
  3. WHERE usesysid = any(grolist);
Advertisement
Add Comment
Please, Sign In to add comment