Convert postgres column type from enum to array of enums
I currently have a table called employees having column access_level of type enum (accessLevel). But now I want to provide the employee multiple access_levels so now I need to convert the datatype from enum to array of enum. I ran the following query ALTER TABLE employees ALTER COLUMN access_level TYPE accessLevel[] USING access_level::accessLevel[] But in… Read More Convert postgres column type from enum to array of enums