/usr/man2/cat.l/drop_tablespace.l.Z(/usr/man2/cat.l/drop_tablespace.l.Z)

NAME

       DROP TABLESPACE - remove a tablespace

SYNOPSIS

       DROP TABLESPACE 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

       tablespacename
              The name of a tablespace.

EXAMPLES

       To remove tablespace mystuff from the system:

       DROP TABLESPACE mystuff;

COMPATIBILITY

       DROP TABLESPACE is a PostgreSQL extension.

SEE ALSO

       CREATE     TABLESPACE    [create_tablespace(l)],    ALTER    TABLESPACE
       [alter_tablespace(l)]

SQL - Language Statements         2005-11-05                 DROP TABLESPACE()