Create A Schema In Postgres

Basic schema creation for a role that has the permissions.

Code

CREATE SCHEMA IF NOT EXISTS new_schema_name;

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

Code

CREATE SCHEMA IF NOT EXISTS new_schema_name AUTHORIZATION role_name;

Full details are in the docs if you need them.