PostgreSQL | Schema

In PostgreSQL, you can create multiple schemas in the same database. Tables and functions are created in schemas, so even within the same database you can create tables with the same name if they are in different schemas. This section explains how to use schemas, including creating and deleting them.

Create a schema

CREATE SCHEMA schema_name AUTHORIZATION username;

Rename a schema

ALTER SCHEMA schema_name RENAME TO new_schema_name;

Change the schema owner

ALTER SCHEMA username OWNER TO new_username;

Delete a schema

DROP SCHEMA schema_name CASCADE;

https://www.postgresql.org/docs/10/static/sql-createschema.html