SHOW TYPES

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

SHOW TYPES does not list . To view domains, use .

Syntax

SHOW TYPES

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

The following example creates a .

> 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)