May 2018
Intermediate to advanced
576 pages
30h 25m
English
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 objects owned by another user within them. This can be especially confusing when you have a schema of the same name as that of the owning user. To avoid this, you should have two types of schema: schemas that are named ...