alter_tablespace(7)

NAME#

ALTER_TABLESPACE - change the definition of a tablespace

SYNOPSIS#

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:

ALTER TABLESPACE index_space RENAME TO fast_raid;

Change the owner of tablespace index_space:

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))