table of contents
CREATE TABLESPACE(7) | PostgreSQL 9.2.24 Documentation | CREATE TABLESPACE(7) |
NAME¶
CREATE_TABLESPACE - define a new tablespace
SYNOPSIS¶
CREATE TABLESPACE tablespace_name [ OWNER user_name ] LOCATION 'directory'
DESCRIPTION¶
CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in the database cluster.
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.
A user with appropriate privileges can pass tablespace_name to CREATE DATABASE, CREATE TABLE, CREATE INDEX or ADD CONSTRAINT to have the data files for these objects stored within the specified tablespace.
PARAMETERS¶
tablespace_name
user_name
directory
NOTES¶
Tablespaces are only supported on systems that support symbolic links.
CREATE TABLESPACE cannot be executed inside a transaction block.
EXAMPLES¶
Create a tablespace dbspace at /data/dbs:
CREATE TABLESPACE dbspace LOCATION '/data/dbs';
Create a tablespace indexspace at /data/indexes owned by user genevieve:
CREATE TABLESPACE indexspace OWNER genevieve LOCATION '/data/indexes';
COMPATIBILITY¶
CREATE TABLESPACE is a PostgreSQL extension.
SEE ALSO¶
CREATE DATABASE (CREATE_DATABASE(7)), CREATE TABLE (CREATE_TABLE(7)), CREATE INDEX (CREATE_INDEX(7)), DROP TABLESPACE (DROP_TABLESPACE(7)), ALTER TABLESPACE (ALTER_TABLESPACE(7))
2017-11-06 | PostgreSQL 9.2.24 |