sequelize postgresql update migration

Question

I'm using sequelize and PostgreSQL and trying to do a simple update via migrations that finds a specific value and udpates it. I have achieved alter table migrations without problem, I must be missing something simple, I can confirm I have a myTable and there is a field named "name" and an entry has a value of "bob".

queryInterface.sequelize.query(`UPDATE 'myTable' SET name = 'bob' WHERE name = 'fred'`)

This is the error I am getting

Unhandled rejection SequelizeDatabaseError: syntax error at or near "'myTable'"

Shivam · Accepted Answer · 2017-07-20 18:34:48Z

1

Should it not be

queryInterface.sequelize.query(`UPDATE myTable SET name = 'bob' WHERE name = 'fred'`)

Single quotes are for proper strings, you could double quotes though. This answer has more info

answered Jul 20, 2017 at 18:34

Shivam

3,6521 gold badge18 silver badges21 bronze badges

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

1 Comment

edencorbin Over a year ago

Yeah double quotes, strange I thought I had tried that, any all working, thanks.

Collectives™ on Stack Overflow

sequelize postgresql update migration

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related