New in v20.2: The SHOW ENUMS statement lists the enumerated data types in the current database.

Synopsis

SHOW ENUMS

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 ENUMS;
  schema |  name   |                  value
---------+---------+-------------------------------------------
  public | weekday | monday|tuesday|wednesday|thursday|friday
  public | weekend | sunday|saturday
(2 rows)

See also



YesYes NoNo