CREATE SCHEMA — define a new schema
CREATE SCHEMA [ IF NOT EXISTS ] schema_name
CREATE SCHEMA
enters a new schema
into the current database.
The schema name must be distinct from the name of any existing schema
in the current database.
A schema is essentially a namespace:
it contains named objects (tables, data types, functions, and operators)
whose names can duplicate those of other objects existing in other
schemas. Named objects are accessed either by “qualifying”
their names with the schema name as a prefix, or by setting a search
path that includes the desired schema(s). A CREATE
command
specifying an unqualified object name creates the object
in the current schema (the one at the front of the search path,
which can be determined with the function current_schema
).
schema_name
The name of a schema to be created. If this is omitted, the
user_name
is used as the schema name.
IF NOT EXISTS
Do nothing if a schema with the same name already exists.
Create a schema:
CREATE SCHEMA myschema;
The IF NOT EXISTS
option is a
Hyper extension.