Schema¶
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).
Properties¶
| Property | Type | Required | Description |
|---|---|---|---|
name |
string |
— | The name of a schema to be created. The name cannot begin with pg_, as such names are reserved for system schemas. |
owner |
string |
— | The role name of the user who will own the new schema. If ommitted, defaults to the project superuser. |
comment |
string |
— | An optional comment about the schema. |
No other properties are accepted.
Source: schemata/schema.yml · Resolved JSON Schema: schema.json