ALTER TABLESPACE

Name

Synopsis

ALTER TABLESPACE name RENAME TO newname
ALTER TABLESPACE name OWNER TO newowner

Description

ALTER TABLESPACE changes the
definition of a tablespace.

You must own the tablespace to use ALTER
TABLESPACE. To alter the owner, you must also be a direct or
indirect member of the new owning role. (Note that superusers
have these privileges automatically.)

Parameters

name

The name of an existing tablespace.

newname

The new name of the tablespace. The new name cannot
begin with pg_, as such names are
reserved for system tablespaces.