Skip to Main Content
Practical PostgreSQL
book

Practical PostgreSQL

by Joshua D. Drake, John C. Worsley
January 2002
Intermediate to advanced content levelIntermediate to advanced
640 pages
16h 39m
English
O'Reilly Media, Inc.
Content preview from Practical PostgreSQL

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

Description

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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

PostgreSQL: Up and Running, 2nd Edition

PostgreSQL: Up and Running, 2nd Edition

Regina O. Obe, Leo S. Hsu
Learning PostgreSQL 11 - Third Edition

Learning PostgreSQL 11 - Third Edition

Christopher Travers, Andrey Volkov
Learn PostgreSQL

Learn PostgreSQL

Luca Ferrari, Enrico Pirozzi
PostgreSQL 13 Cookbook

PostgreSQL 13 Cookbook

Vallarapu Naga Avinash Kumar

Publisher Resources

ISBN: 9781449309770Supplemental ContentErrata Page