How to delete an array of keys from a Postgres jsonb object?

Question

I have a jsonb object that I want to remove keys from. I have a jsonb array that holds the keys that I want to remove from the object. I see documentation for deleting a single key, like this:

SELECT '{"foo": true, "bar": false, "baz": true}'::jsonb - 'foo'

Returns {"bar": false, "baz": true}

But I don't see any documentation on removing multiple keys at once, say from a Postgres or jsonb array. I'd like to do something along the lines of this pseudocode:

SELECT '{"foo": true, "bar": false, "baz": true}'::jsonb - '["foo", "bar"]'::jsonb
-- I'd like to return {"baz": true}

How can I delete an array of keys from a jsonb object?

Laurenz Albe · Accepted Answer · 2019-04-12 15:27:06Z

3

Use the - operator with an array of text on the right hand side:

SELECT '{"foo": true, "bar": false, "baz": true}'::jsonb
       - '{foo,bar}'::text[];

answered Apr 12, 2019 at 15:27

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Collectives™ on Stack Overflow

How to delete an array of keys from a Postgres jsonb object?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related