SQL

postgresql Create a new role with a username and password

CREATE ROLE username NOINHERIT LOGIN PASSWORD password;

postgresql create role

CREATE ROLE role_name;

postgresql create role

CREATE ROLE role_name with NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;

create role postgres

CREATE ROLE <name> WITH <list of permissions>;