Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.

create table table_name (data json);
insert into table_name values ('{"fruit":"apple", "color":"blue"}');

CREATE TABLE

INSERT 0 1

update table_name set data = (select json_agg(json_build_object(v.key, v.value)) 
                              from json_each(data) v)

UPDATE 1

select * from table_name;

data

[{"fruit" : "apple"}, {"color" : "blue"}]

SELECT 1