SHOW TYPES statement lists the user-defined data types in the current database: enumerated, composite, and domain data types.
Syntax
Required privileges
TheCONNECT privilege on the database is required to list any user-defined types in the database.
Examples
The following example creates two user-defined types and a domain.category column shows whether each type is an enum, composite, or domain type:

