SHOW TYPES

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

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)