—
NAME
ALTER_TABLESPACE - change the definition of a tablespace
SYNOPSIS
bash
ALTER TABLESPACE \nname\n RENAME TO \nnew_name\n
ALTER TABLESPACE \nname\n OWNER TO { \nnew_owner\n | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER TABLESPACE \nname\n SET ( \ntablespace_option\n = \nvalue\n [, ... ] )
ALTER TABLESPACE \nname\n RESET ( \ntablespace_option\n [, ... ] )DESCRIPTION
ALTER TABLESPACE can be used to change the definition of a tablespace.
You must own the tablespace to change the definition of a tablespace. To alter the owner, you must also be able to SET ROLE to the new owning role. (Note that superusers have these privileges automatically.)
PARAMETERS
name
new_name
new_owner
tablespace_option
EXAMPLES
Rename tablespace index_space to fast_raid:
bash
ALTER TABLESPACE index_space RENAME TO fast_raid;Change the owner of tablespace index_space:
bash
ALTER TABLESPACE index_space OWNER TO mary;COMPATIBILITY
There is no ALTER TABLESPACE statement in the SQL standard.
SEE ALSO
CREATE TABLESPACE (CREATE_TABLESPACE(7)), DROP TABLESPACE (DROP_TABLESPACE(7))