Sequelize bulkCreate updateOnDuplicate for postgresQL?

Question

I know there is no support for updateOnDuplicate for postgresQL by Sequelize sequelize doc, so is there a work around for this?

Can it be implemented via "SQL command".

Muhammed Kalkan · Accepted Answer · 2019-12-25 12:09:08Z

6

New sequelize (v5) includes updateOnDuplicate feature for all dialects

Fields to update if row key already exists (on duplicate key update)? (only supported by MySQL, MariaDB, SQLite >= 3.24.0 & Postgres >= 9.5). By default, all fields are updated.

Check here : Docs

You can use as

model.bulkCreate(dataToUpdate, { updateOnDuplicate: ["user_id", "token", "created_at"] })

answered Dec 25, 2019 at 12:09

Muhammed Kalkan

1011 silver badge7 bronze badges

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

Comments

sawim · Accepted Answer · 2019-04-05 10:43:06Z

3

There is some work around. See upsert function. When used in Postgresql it creates custom function in database. Unfortunately there is no bulkUpsert, so you either use it in some for-loop or execute raw SQL as suggested here.

answered Apr 5, 2019 at 10:43

sawim

1,0828 silver badges18 bronze badges

Collectives™ on Stack Overflow

Sequelize bulkCreate updateOnDuplicate for postgresQL?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related