SHOW ENUMS

The SHOW ENUMS statement lists the in the current database.

Syntax

Parameters

Parameter	Description
name name.name	The name of the from which to show enumerated data types, or the name of the and the , separated by a “.”.

Examples

The following example creates a .

> CREATE TYPE weekday AS ENUM ('monday', 'tuesday', 'wednesday', 'thursday', 'friday');

> CREATE TYPE weekend AS ENUM ('sunday', 'saturday');

> SHOW ENUMS;

  schema |  name   |                   values                   | owner
---------+---------+--------------------------------------------+--------
  public | weekday | {monday,tuesday,wednesday,thursday,friday} | demo
  public | weekend | {sunday,saturday}                          | demo
(2 rows)

> SHOW ENUMS FROM movr.public;

  schema |  name   |                   values                   | owner
---------+---------+--------------------------------------------+--------
  public | weekday | {monday,tuesday,wednesday,thursday,friday} | demo
  public | weekend | {sunday,saturday}                          | demo
(2 rows)

See also