Postgresql 中文操作指南

DROP TABLESPACE

DROP TABLESPACE — 删除表空间

DROP TABLESPACE — remove a tablespace

Synopsis

DROP TABLESPACE [ IF EXISTS ] name

Description

DROP TABLESPACE 从系统中删除一个表空间。

DROP TABLESPACE removes a tablespace from the system.

仅表空间所有者或超级用户可以删除表空间。在删除表空间之前，表空间必须不包含所有数据库对象。即使当前数据库中没有对象在使用表空间，其他数据库中的对象也可能仍然驻留在表空间中。此外，如果表空间列在任何活动会话的 temp_tablespaces 设置中，则 DROP 可能会由于临时文件驻留在表空间中而失败。

A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are using the tablespace. 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.

Parameters

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.

Notes

DROP TABLESPACE 无法在事务块内执行。

DROP TABLESPACE cannot be executed inside a transaction block.

Examples

要从系统中删除表空间 mystuff ：

To remove tablespace mystuff from the system:

DROP TABLESPACE mystuff;

Compatibility

DROP TABLESPACE 是一个 PostgreSQL 扩展。

DROP TABLESPACE is a PostgreSQL extension.