perrosnk
Reputation: 935
How to alter Postgres column type from ENUM to VARCHAR
I have a column with type ENUM. The possible values are "public, private, followers".
How can I convert the column type to varchar without losing the values?
The postgres version is 9.6
Upvotes: 6
Views: 5331
Answers (1)
Oto Shavadze
Reputation: 42853
Yes, you can
alter table table_name alter column col_name TYPE varchar;
Upvotes: 12
Related Questions
- Upgrading enum type column to varchar in postgresql
- How to change the data type of a table column to enum?
- How to update a postgres table column and set the values to and enum type
- How do I change a text to an enum type?
- Migrating existing VARCHAR values to an Enum in Postgres 8
- Alter column type to enum with mapping
- Upgrading a varchar column to enum type in postgresql
- Alter type Integer to Enum in Postgres
- Upgrading an int column to enum type in postgresql
- PostgreSQL: changing a column of enum type