Provided by: postgresql-client-8.4_8.4.4-2_i386 bug

NAME

       DROP TYPE - remove a data type

SYNOPSIS

       DROP TYPE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION

       DROP  TYPE  removes a user-defined data type.  Only the owner of a type
       can remove it.

PARAMETERS

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

       name   The  name  (optionally  schema-qualified)  of  the  data type to
              remove.

       CASCADE
              Automatically drop objects that depend  on  the  type  (such  as
              table columns, functions, operators).

       RESTRICT
              Refuse to drop the type if any objects depend on it. This is the
              default.

EXAMPLES

       To remove the data type box:

       DROP TYPE box;

COMPATIBILITY

       This command is  similar  to  the  corresponding  command  in  the  SQL
       standard,  apart  from  the  IF  EXISTS  option,  which is a PostgreSQL
       extension.  But note that the CREATE TYPE command  and  the  data  type
       extension mechanisms in PostgreSQL differ from the SQL standard.

SEE ALSO

       CREATE TYPE [create_type(7)], ALTER TYPE [alter_type(7)]