POSTGRESQL: CREATE TABLESPACE
top of page
CerebroSQL

PostgreSQL:  

CREATE TABLESPACE

Topic

CREATE TABLESPACE tablespace_name
[ OWNER user_name ]
LOCATION 'directory'
[ WITH ( tablespace_option = value [, ... ] ) ]

Example

CREATE TABLESPACE dbspace LOCATION '/data/dbs';
CREATE TABLESPACE indexspace OWNER genevieve LOCATION
'/data/indexes';

bottom of page