Drop Type
Removes a type from the system catalogs.
Synopsis
DROP TYPE typename [, ...]
Parameters
typename
The name of a type you wish to remove. You may drop multiple types by specifying their names in a comma-delimited list.
Results
DROP
The message returned when a type is dropped successfully.
ERROR: RemoveType: type '
typename
' does not exist
The error displayed if the type
typename
is not found in the connected database.
Description
Use the DROP TYPE
command to remove a type from the database system.
Only the owner of a type, or a superuser, is allowed to do this.
Note
If you are logged in as a superuser, you will be able to drop system types. However, doing so can cause extreme instability. Be careful!
The DROP TYPE
command will not automatically remove any objects that
reference the data type, or types, that you are dropping. Once a data type is removed,
anything that uses it will most likely stop working. Be sure to remove objects that depend on
types that you drop, and be sure not to drop types used by objects you wish to keep.
Examples
The following command removes the zero
data type from the booktown
database:
booktown=# DROP TYPE zero;
DROP
Get Practical PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.