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).
ALTER FILESPACE myfs RENAME TO fast_ssd;
Change the owner of tablespace
ALTER FILESPACE myfs OWNER TO dba;
There is no
ALTER FILESPACE statement in the SQL standard or in PostgreSQL.
gpfilespace in the Greenplum Database Utility Guide
Parent topic: SQL Command Reference