pg_user1.htm

SELECT usename, usesysid, usesuper FROM pg_user