Index for Section TABLESPACE

Alphabetical listing for D

Bottom of page

DROP
NAME
  DROP TABLESPACE - remove a tablespace

SYNOPSIS
  DROP TABLESPACE [ IF EXISTS ] tablespacename

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 may still reside in the
  tablespace even if no objects in the current database are using the
  tablespace.

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

  tablespacename
       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.

SEE ALSO
  CREATE TABLESPACE [create_tablespace(5)], ALTER TABLESPACE
  [alter_tablespace(l)]

Index for Section TABLESPACE

Alphabetical listing for D

Top of page