Create A Schema In Postgres

November - 2021

Basic schema creation for a role that has the permissions.

CREATE SCHEMA IF NOT EXISTS new_schema_name;

To set the owner of a new schema to another role, use:

CREATE SCHEMA IF NOT EXISTS new_schema_name AUTHORIZATION role_name;

Full details are in the docs if you need them.