ALTER FILESPACE

Changes the definition of a filespace.

Synopsis

ALTER FILESPACE <name> RENAME TO <newname>

ALTER FILESPACE <name> OWNER TO <newowner>

Description

ALTER FILESPACE changes the definition of a filespace.

You must own the filespace to use ALTER FILESPACE. 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 filespace.
newname: The new name of the filespace. The new name cannot begin with pg_ or gp_ (reserved for system filespaces).
newowner: The new owner of the filespace.

Examples

Rename filespace myfs to fast_ssd:

ALTER FILESPACE myfs RENAME TO fast_ssd;

Change the owner of tablespace myfs:

ALTER FILESPACE myfs OWNER TO dba;

Compatibility

There is no ALTER FILESPACE statement in the SQL standard or in PostgreSQL.