Creating a schema in greenplum

Define a new Schema in Greenplum

CREATE SCHEMA schema_name [AUTHORIZATION username]

[schema_element [ ... ]]

CREATE SCHEMA AUTHORIZATION rolename [schema_element [ ... ]]

A schema is essentially a namespace: it contains named objects (tables, data types, functions, and operators) whose names may 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).

ALTER SCHEMA name RENAME TO newname
ALTER SCHEMA name OWNER TO newowner

DROP SCHEMA [IF EXISTS] name [, ...] [CASCADE | RESTRICT]

Comments