> [TOC] ## 枚舉類型 創建枚舉語法 ``` CREATE TYPE name AS ENUM ( label_1 [, label_2, ... ] ); ``` ### 添加枚舉類型 ``` CREATE TYPE my_week AS ENUM ( 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday', 'Sunday' ); ``` ### 查看枚舉類型 ``` > select * from pg_enum; ``` ### 創建帶枚舉類型的表 ``` CREATE TABLE week_day_sales ( id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY, week_day my_week NOT NULL, sales integer NOT NULL ); ``` ### 插入數據 ``` INSERT INTO week_day_sales (week_day, sales) VALUES ('Monday', 110), ('Tuesday', 120), ('Wednesday', 130); ```