How do you create and manage database roles and users? What is the difference between a role and a user in PostgreSQL?

Sample answer preview

In PostgreSQL, roles are the unified mechanism for managing both individual user accounts and groups of privileges. Understanding how roles work is fundamental for a junior DBA responsible for access management.