Enumerated type - Enum - PostgreSQL
Note: this page is outdated. Please visit the latest page Enumerated type – Enum – PostgreSQL
Enumerated types in PostgreSQL projects can be created as reusable objects. In the main toolbar click Other and select Enum from the drop-down.
Then click the diagram area to place a new graphical representative to the desired position.
In the right-side panel, you can specify the Name for the Enum type and Enum values.
If you wish to see the generated code, click tab Script in the right-side panel.
How to use the Enum type in your PostgreSQL project?
Enumerated types can be selected in the same way as standard data types. You can pick the Enum type from the datatype drop-down.
Tip: A default value can be defined for the column. Expand the column detail by clicking the arrow icon and specify the value in the Default value field.
Generated SQL for the selected table: