updating a JSONb field in a postgres

Question

I have a table world with a field v (jsonb) and workflow_id (int). I want to run the command: UPDATE world SET v = {'a': 1} WHERE workflow_id = 84; This gives me a syntax error - I've tried putting quotation marks around the json value in all of the different combinbations I can think of but nothing works. If I try "{'a':1}", it tells me that column "{'a':1}" does not exist.

Any help would be appreciated.

Have you tried to do it as described in postgres documentation postgresql.org/docs/current/static/datatype-json.html? — Roman-Stop RU aggression in UA
– Roman-Stop RU aggression in UA, Commented Jul 16, 2015 at 20:02

Sagar Koshti · Accepted Answer · 2015-07-22 19:05:48Z

2

Try

UPDATE world SET v = '{"a": 1}::jsonb' WHERE workflow_id = 84;

cause you need to cast your text to jsonb datatype.

else you can also try

UPDATE world SET v = CAST('{"a": 1}' AS JSONB) WHERE workflow_id = 84;

answered Jul 22, 2015 at 19:05

Sagar Koshti

4382 gold badges6 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

updating a JSONb field in a postgres

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related