ALTER TABLESPACE — change the definition of a tablespace
ALTER TABLESPACEname
RENAME TOnewname
ALTER TABLESPACEname
OWNER TOnewowner
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.)
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.
newowner
The new owner of the tablespace.