SHOW TYPES

The SHOW TYPES statement lists the user-defined data types in the current database.

SHOW TYPES does not list domain data types. To view domains, use SHOW CREATE ALL TYPES.

Syntax

SHOW TYPES

The CONNECT privilege on the database is required to list any user-defined types in the database.

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)