DROP TABLESPACE

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.

• IF EXISTS

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

• name

  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.