On this page
Warning:
As of June 5, 2024, CockroachDB v22.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 |
---|---|
name name.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)