Tablespace¶
A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such as tables and indexes) can reside.
Properties¶
| Property | Type | Required | Description |
|---|---|---|---|
name |
string |
yes | The name of the tablespace function to create. |
owner |
string |
— | The role that owns the tablespace function. |
location |
string |
yes | The directory that will be used for the tablespace. The directory must exist (CREATE TABLESPACE will not create it), should be empty, and must be owned by the PostgreSQL system user. The directory must be specified by an absolute path name. |
options |
object |
— | The parameters of the tablespace, by name. Each value is a number. |
comment |
string |
— | An optional comment about the tablespace. |
security_labels |
security_labels | — | Security Labels. |
No other properties are accepted.
Source: schemata/tablespace.yml · Resolved JSON Schema: tablespace.json