devi

CREATE OR REPLACE FUNCTION public.json_append(data json, insert_data json)
RETURNS json
IMMUTABLE
LANGUAGE sql
AS $$
    SELECT ('{'||string_agg(to_json(key)||':'||value, ',')||'}')::json
    FROM (
        SELECT * FROM json_each(data)
        UNION ALL
        SELECT * FROM json_each(insert_data)

devi

CREATE FUNCTION jb_merge(jsonb, jsonb)
RETURNS jsonb
IMMUTABLE
LANGUAGE SQL
AS $$
  WITH xxx AS
    (SELECT * FROM jsonb_each_text($1)
       UNION ALL
     SELECT * FROM jsonb_each_text($2))
  SELECT json_object_agg(key, value)::jsonb FROM xxx;