For using enum type we need to create it first, without creating we cannot use into the table.If we have use same type of value into the column, same time we have used enum type on the table column.Below is the working of enum type in PostgreSQL.Add value вЂ“This is defined as add a new value to the enum type by using the alter type command.We can add a new value into the enum data set to use the same into the table. Alter type вЂ“We can alter enum type after creation, we can modify the enum type by using the alter type command.Value 1 to value N вЂ“This is defined as column field value which was used at the time of insertion into the table.We have also define enum type to the column. Name of column 1 to name of column N вЂ“This is defined as name of column which was we have used at the time of table creation.Create table вЂ“ This is defined as create a table by using the enum type, we can define enum type to the column in PostgreSQL.We can define multiple value in enum type, after defining the same we have using this into the table at the time of insertion. Value of enum type 1 to value of enum type N вЂ“This is defined as set of value which was we have used in enum data type.Name of table вЂ“This is defined as name of table on which column we have defining enum data type.We can use this data type on a column at the time of table creation. Name of enum type вЂ“This is define as create enum type and use this in table at the time of table creation.Create type вЂ“ This is defined as create enum data type using create type in PostgreSQL.Insert into name_of_table (name_of_column1, name_of_enum_type_column2, name_of_column3, вЂ¦, name_of_columnN) values (value1, value_of_enum_type, value2, value3, вЂ¦., ValueN) ДЄlter type name_of_enum_type add value вЂvalue_of_enum_typeвЂ™ AFTER вЂvalue_of_enum_typeвЂ™ Д«elow is the parameter description syntax of enum type in PostgreSQL.

Insert a value of enum data type column.Hadoop, Data Science, Statistics & othersД«elow is the syntax of enum in PostgreSQL:Д¬reate type name_of_enum_type (value_of_enum_type1, value_of_enum_type2, value_of_enum_type3, вЂ¦, value_of_enum_typeN) Д¬reate table name_of_table (name_of_column1 data_type, name_of_column2 enum_type, name_of_column3 data_type, вЂ¦, name_of_columnN data_type)

Iterm not found in postgres app