Remove multiple keys from jsonb column in one statement

Question

I'm trying to remove multiple keys from a jsonb column.

I've managed to get it to delete a single key with the following statement:

UPDATE table_a
SET data_column = data_column #- '{attr_1}'
WHERE type = 'type_a'

I understand thats a path so I can't do: #- '{attr_1,attr_2}

Based on the docs I should be able to also do - 'attr_1' but that didn't work otherwise I'd attempt to try - 'attr_1,attr2'

Answer 1

Or the minus operator once (but using a text array):

SELECT '{ "a": 1, "b": 2, "c": 3 }'::jsonb - '{a,b}'::text[];
 ?column? 
----------
 {"c": 3}
(1 row)

Answer 2

If you need to remove multiple non-nested keys you can use - operator:

SELECT '{ "a": 1, "b": 2, "c": 3 }'::jsonb - ARRAY['a', 'b'];