DROP FILESPACE

    Description

    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.

    Do not throw an error if the filespace does not exist. A notice is issued in this case.

    tablespacename

    Examples

    Remove the tablespace :

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

    See Also

    Parent topic: SQL Command Reference