list database roles postgres code example

Example: get role postgres

SELECT rolname FROM pg_roles;