DROP TABLESPACE — remove a tablespace
DROP TABLESPACE [ IF EXISTS ] name
DROP TABLESPACE removes a tablespace from the system.
A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of database objects before it can be dropped. Also, if the tablespace is listed in the temp_tablespaces setting of any active session, the
DROP might fail due to temporary files residing in the tablespace.
Do not throw an error if the tablespace does not exist. A notice is issued in this case.
The name of a tablespace.
DROP TABLESPACE cannot be executed inside a transaction block.
To remove tablespace
mystuff from the database:
DROP TABLESPACE mystuff;
DROP TABLESPACE is a PostgreSQL extension.