Home
NOTE: I'm in the middle of upgrading the site. Most things are in place, but some things are missing and/or broken. This includes alt text for images. Please bear with me while I get things fixed.

Create A Schema In Postgres

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.

~ fin ~