drop_tablespace - phpMan

DROP TABLESPACE()                SQL Commands                DROP TABLESPACE()



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

       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(7)], ALTER TABLESPACE [alter_tablespace(l)]



SQL - Language Statements         2009-03-12                 DROP TABLESPACE()

Generated by $Id: phpMan.php,v 4.54 2007/08/21 09:05:22 chedong Exp $ Author: Che Dong
On Apache/2.2.3 (Red Hat)
Under GNU General Public License
2009-11-25 16:11 @127.0.0.1 CrawledBy CCBot/1.0 (+http://www.commoncrawl.org/bot.html)