A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
Changes the definition of a filespace.
ALTER FILESPACE name RENAME TO newname ALTER FILESPACE name OWNER TO newowner
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).
- The name of an existing filespace.
- The new name of the filespace. The new name cannot begin with pg_ or gp_ (reserved for system filespaces).
- The new owner of the filespace.
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;
There is no ALTER FILESPACE statement in the SQL standard or in PostgreSQL.
DROP FILESPACE, gpfilespace in the Greenplum Database Utility Guide