Separating groups of objects is a good way of improving administration efficiency. We need to know how to create new schemas and remove schemas that are no longer required.
To add a new schema, issue the following command:
CREATE SCHEMA sharedschema;
If you want that schema to be owned by a particular user, then you can add the following option:
CREATE SCHEMA sharedschema AUTHORIZATION scarlett;
Or, if you want to create a new schema which has the same name as an existing user, so that the user becomes the owner, then try the following:
CREATE SCHEMA AUTHORIZATION scarlett;
In many database systems, the schema name is the same as the owning user. PostgreSQL allows schemas owned by one user to have objects owned ...