Various POSTGRESQL helpers

merge_json.sql

with
  test as (
    select *
      from (
          values
          (123, '{"key_1": {"value_1": 1}}'::jsonb),
          (123, '{"key_2": {"value_2": 2}}'::jsonb),
          (123, '{"key_3": {"value_3": 3}}'::jsonb),
          (456, '{"key_4": {"value_4": 4}}'::jsonb),
          (456, '{"key_1": {"value_3": 4}}'::jsonb)
          )
        as t (id, values)
    )
select id, jsonb_object_agg(t.k, t.v)
  from test, jsonb_each(values::jsonb) as t(k,v)
group by id
order by id
;

+---+---------------------------------------------------------------------------+
|id |jsonb_object_agg                                                           |
+---+---------------------------------------------------------------------------+
|123|{"key_1": {"value_1": 1}, "key_2": {"value_2": 2}, "key_3": {"value_3": 3}}|
|456|{"key_1": {"value_3": 4}, "key_4": {"value_4": 4}}                         |
+---+---------------------------------------------------------------------------+

object_owner.sql

SELECT
  proname,
  proowner::regrole
FROM pg_proc
WHERE pronamespace::regnamespace::text = 'customer';