Sequelize PostgreSQL: Change Column type string to array of String

Question

I'm using the Sequelize ORM with PostgreSQL.

I need to Change the type of a column from String to Array[String].

I used this migration Script

up: (queryInterface, Sequelize) => { return queryInterface.changeColumn('email','to', { type:Sequelize.ARRAY(Sequelize.TEXT), allowNull: false }); }

ERROR: column "to" cannot be cast automatically to type text[]

I tried the answer from this link but It does not work for me

Please let me know If I'm doing something wrong.

Vishnu Mishra · Accepted Answer · 2017-12-07 06:59:40Z

2

It was issue with [email protected]

Downgrading to [email protected] fixes the issue.

answered Dec 7, 2017 at 6:59

Vishnu Mishra

4,0493 gold badges27 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sequelize PostgreSQL: Change Column type string to array of String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related