CREATE TABLESPACE

Function

Creates a tablespace in a database.

Precautions

• This section describes only the new syntax of Dolphin. The original syntax of openGauss is not deleted or modified.

Syntax

CREATE TABLESPACE tablespace_name
    tablespace_details;

In the preceding information, tablespace_details is as follows:

[ OWNER user_name ] [RELATIVE] LOCATION 'directory' [ MAXSIZE 'space_size' ] [with_option_clause] [ ENGINE [=] engine_name ]
| ADD DATAFILE 'directory' [ ENGINE [=] engine_name ]

Parameter Description

• ENGINE [=] engine_name

  Specifies the storage engine. Currently, it is used only for syntax and has no actual purpose.

Examples

--Run the ADD DATAFILE syntax to create a tablespace.
CREATE TABLESPACE t_tbspace ADD DATAFILE 'my_tablespace' ENGINE = test_engine;
CREATE TABLESPACE