On this page 
Warning:
As of May 16, 2023, CockroachDB v21.2 is no longer supported. For more details, refer to the Release Support Policy.
The SHOW ENUMS statement lists the enumerated data types in the current database.
Syntax
Parameters
| Parameter | Description |
|---|---|
namename.name |
The name of the schema from which to show enumerated data types, or the name of the database and the schema, separated by a ".". |
Examples
> 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
Was this helpful?
