On this page
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
The following example creates a user-defined type.
> 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)