postgresql users and roles code example

Example 1: postgresql create user roles

CREATE ROLE admin WITH CREATEDB CREATEROLE;

CREATE ROLE name [ WITH ADMIN role_name ]