New in v20.2: The SHOW TYPES statement lists the user-defined data types in the current database.

Note:

CockroachDB currently only supports enumerated user-defined types. As a result, SHOW ENUMS and SHOW TYPES return the same results.

Syntax

SHOW TYPES

Required privileges

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

Examples

copy
icon/buttons/copy
> CREATE TYPE weekday AS ENUM ('monday', 'tuesday', 'wednesday', 'thursday', 'friday');
copy
icon/buttons/copy
> CREATE TYPE weekend AS ENUM ('sunday', 'saturday');
copy
icon/buttons/copy
> SHOW TYPES;
  schema |  name   |                  value
---------+---------+-------------------------------------------
  public | weekday | monday|tuesday|wednesday|thursday|friday
  public | weekend | sunday|saturday
(2 rows)

See also



Yes No