From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-droptablespace.html | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 doc/src/sgml/html/sql-droptablespace.html (limited to 'doc/src/sgml/html/sql-droptablespace.html') diff --git a/doc/src/sgml/html/sql-droptablespace.html b/doc/src/sgml/html/sql-droptablespace.html new file mode 100644 index 0000000..2e58cc2 --- /dev/null +++ b/doc/src/sgml/html/sql-droptablespace.html @@ -0,0 +1,28 @@ + +DROP TABLESPACE
DROP TABLESPACE
Prev UpSQL CommandsHome Next

DROP TABLESPACE

DROP TABLESPACE — remove a tablespace

Synopsis

+DROP TABLESPACE [ IF EXISTS ] name
+

Description

+ 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 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 cannot be executed inside a transaction block. +

Examples

+ To remove tablespace mystuff from the system: +

+DROP TABLESPACE mystuff;
+

Compatibility

+ DROP TABLESPACE is a PostgreSQL + extension. +

Prev Up Next
DROP TABLE Home DROP TEXT SEARCH CONFIGURATION
\ No newline at end of file -- cgit v1.2.3