Postgres schema

CREATE ROLE <role_name> WITH LOGIN PASSWORD 'your_password' VALID UNTIL '';

ALTER ROLE <role_name> SET search_path TO ;

CREATE SCHEMA IF NOT EXISTS  AUTHORIZATION ;

SHOW search_path;

UPDATE pg_database set datallowconn = 'false' where datname = 'xxx'