CREATE TYPE mood AS ENUM8 ('sad', 'ok', 'happy'); SELECT fld_specific_info FROM (SHOW TYPES) WHERE fld_name = 'mood';