Retrieve role details

Retrieves information about the specified Postgres role.