postgres=# SELECT json_append('{"a": 1}', '{"b": 2, "c": 3, "a": 4}'); json_append --------------------------- {"a":1,"b":2,"c":3,"a":4} (1 row) postgres=# SELECT json_delete('{"b": 2, "c": 3, "a": 4}', '{b, c}'); json_delete ------------- {"a":4} (1 row) postgres=# SELECT json_update('{"a": 1}', '{"b": 2, "c": 3, "a": 4}'); json_update ------------- {"a":4} (1 row) postgres=# SELECT json_merge('{"a": 1}', '{"b": 2, "c": 3, "a": 4}'); json_merge --------------------- {"b":2,"c":3,"a":4} (1 row)