On this page 
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)
