Update multiple values in a jsonb data in PostgreSQL

Question

I need to update a jsonb data(column->users) in my table 'settings' My jsonb data is like

'{
    "Email": "aaaa",
    "UserId": "49",
    "Created": "11/13/2016",
    "EntityId": "1",
    "IsActive": "False",
    "Modified": "11/13/2016",
    "Username": "aa"
}'

In this json string I need to update Email,IsActive,Username together. I tried the below update query,its working fine. But that is for a single value updation.

UPDATE settings 
SET users = jsonb_set(users, '{Email}', '"aa"') 
WHERE users @> '{"UserId":"49"}';

How to update for multiple value updation? I am using postgres 9.5.

Possible duplicate of postgres jsonb_set multiple keys update — uLan
– uLan, Commented Oct 26, 2017 at 3:51

klin · Accepted Answer · 2016-11-14 07:34:04Z

26

Use the concatenation operator:

UPDATE settings 
SET users = users || '{"Email": "new email", "IsActive": "True", "Username": "new username"}'
WHERE users @> '{"UserId":"49"}';

answered Nov 14, 2016 at 7:34

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

Update multiple values in a jsonb data in PostgreSQL

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related