Skip to main content
The SHOW TYPES statement lists the user-defined data types in the current database: enumerated, composite, and domain data types.

Syntax

Required privileges

The CONNECT 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.
The category column shows whether each type is an enum, composite, or domain type:

See also