create a postgresql role and user 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 ]