what is the difference between role and user in postgresql?
Staff member A role can be a user, a group, or both. A role can can have privileges on databases, and can own objects within databases, such as tables. The primary difference between a PostgreSQL user and a role is that a user has the LOGIN privilege assumed when the user is created, whereas a role has NOLOGIN assumed.