Defines a new tablespace.
CREATE TABLESPACE <tablespace_name> [OWNER <username>] FILESPACE <filespace_name>
CREATE TABLESPACE registers a new tablespace for your HAWQ system. The tablespace name must be distinct from the name of any existing tablespace in the system.
A tablespace allows superusers to define an alternative location on the file system where the data files containing database objects (such as tables) may reside.
In HAWQ, there must be a file system location defined for the master and each segment in order for the tablespace to have a location to store its objects across an entire HAWQ system. This collection of file system locations is defined in a filespace object. A filespace must be defined before you can create a tablespace. See hawq filespace for more information.
pg_, as such names are reserved for system tablespaces.
hawq filespacemanagement utility.
You must first create a filespace to be used by the tablespace. See hawq filespace for more information.
Tablespaces are only supported on systems that support symbolic links.
CREATE TABLESPACE cannot be executed inside a transaction block.
Create a new tablespace by specifying the corresponding filespace to use:
CREATE TABLESPACE mytblspace FILESPACE myfilespace;
CREATE TABLESPACE is a HAWQ extension.