postgres create role with permissions code example

Example 1: postgresql create user roles

CREATE ROLE admin WITH CREATEDB CREATEROLE;

Example 2: postgresql create user roles

CREATE ROLE name [ WITH ADMIN role_name ]