Home
Head's Up: I'm in the middle of upgrading my site. Most things are in place, but there are something missing and/or broken including image alt text. Please bear with me while I'm getting things fixed.

Create A Schema In Postgres

Basic schema creation for a role that has the permissions.

sql
CREATE SCHEMA IF NOT EXISTS new_schema_name;

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

sql
CREATE SCHEMA IF NOT EXISTS new_schema_name AUTHORIZATION role_name;

Full details are in the docs if you need them.