Removes a filespace.
DROP FILESPACE [IF EXISTS] <filespacename>
DROP FILESPACE removes a filespace definition and its system-generated data directories from the system.
A filespace can only be dropped by its owner or a superuser. The filespace must be empty of all tablespace objects before it can be dropped. It is possible that tablespaces in other databases may still be using a filespace even if no tablespaces in the current database are using the filespace.
Remove the tablespace
DROP FILESPACE myfs;
There is no
DROP FILESPACE statement in the SQL standard or in PostgreSQL.