HOW TO GIVE USER AN EXISTING ROLE POSTGRES code example
Example 1: postgresql change user role grant
=# ALTER USER librarian WITH SUPERUSER;
ALTER ROLE
Example 2: postgresql create user roles
CREATE ROLE name [ WITH ADMIN role_name ]
=# ALTER USER librarian WITH SUPERUSER;
ALTER ROLE
CREATE ROLE name [ WITH ADMIN role_name ]