Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

Databases - Practical PostgreSQL
Previous Page Home Next Page

DROP TYPE

Name

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

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

Warning

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
Databases - Practical PostgreSQL
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire