On this page 
The SHOW TYPES statement lists the user-defined data types in the current database.
Syntax
SHOW TYPES
Required privileges
The CONNECT privilege on the database is required to list any user-defined types in the database.
Examples
The following example creates a user-defined type.
> CREATE TYPE weekday AS ENUM ('monday', 'tuesday', 'wednesday', 'thursday', 'friday');
> CREATE TYPE weekend AS ENUM ('sunday', 'saturday');
> SHOW TYPES;
schema | name | owner
---------+---------+--------
public | weekday | root
public | weekend | root
(2 rows)
See also
Was this helpful?
