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.
See Also
DROP FILESPACE, gpfilespace in the Greenplum Database Utility Guide