POSTGRESQL: ALTER TABLESPACE
top of page
CerebroSQL

PostgreSQL:  

ALTER TABLESPACE

Topic

ALTER TABLESPACE name RENAME TO new_name
ALTER TABLESPACE name OWNER TO new_owner
ALTER TABLESPACE name SET ( tablespace_option = value [, ... ] )
ALTER TABLESPACE name RESET ( tablespace_option [, ... ] )

Example

ALTER TABLESPACE index_space RENAME TO fast_raid;
ALTER TABLESPACE index_space OWNER TO mary;

bottom of page