how to see postgres roles and users code example

Example: get role postgres

SELECT rolname FROM pg_roles;