SequelizeJS - insert JSONB to Postgres with raw query - how to escape

Question

I want to insert a row with JSONB content as a raw query. The problem is that I get error wherever I insert any "nontrivial" JSON object.

These are examples of my raw SQL queries:

Error for all of these: SequelizeBaseError: invalid input syntax for type json

'INSERT INTO "sometable" ("id", "createdAt", "updatedAt", "custom_data") VALUES (DEFAULT, NOW(), NOW(), \'"{something:\"value\"}"\')';
'INSERT INTO "sometable" ("id", "createdAt", "updatedAt", "custom_data") VALUES (DEFAULT, NOW(), NOW(), \'"{\"aaa\":\"ss15\"}"\')';

This last one works, but only with integer values:

'INSERT INTO "sometable" ("id", "createdAt", "updatedAt", "custom_data") VALUES (DEFAULT, NOW(), NOW(), \'"{a:10}"\')';

I've tried so many possible combinations of escaping the JSON-like string, even inserting real JS object, and nothing worked.

Avraham · Accepted Answer · 2017-05-03 22:24:37Z

13

Try to JSON.stringify() first:

var customData = JSON.stringify({"name":"George Washington","presidentNo":1});

answered May 3, 2017 at 22:24

Avraham

9781 gold badge14 silver badges28 bronze badges

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

1 Comment

GavinBelson Over a year ago

Confirmed on Sequelize V6 as well

Collectives™ on Stack Overflow

SequelizeJS - insert JSONB to Postgres with raw query - how to escape

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related