Separating groups of objects is a good way of improving administration efficiency. You need to know how to create new schemas and remove schemas that are no longer required.
Adding/removing schemas
How to do it...
To add a new schema, issue this 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;
If you want to create a new schema that has the same name as an existing user, so that the user becomes the owner, then try this:
CREATE SCHEMA AUTHORIZATION scarlett;
In many database systems, the schema name is the same as that of the owning user. PostgreSQL allows schemas owned by one user to have...