PostgreSQL – Drop Type

You can remove a user defined data type using below syntax:

DROP TYPE typename;

See also  PostgreSQL - Get database size