How Do I View All Database Users and Their Permissions?

	
SELECT * FROM pg_user; 

	
SELECT * FROM pg_authid; 

SELECT * FROM pg_authid where rolname = 'joe';