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 the_table (column1 text, column2 int, column3 int);
CREATE TABLE
insert into the_table
values
('name 1', 0, 10),
('name 2', 0, 10),
('name 3', 0, 10);
INSERT 0 3
select jsonb_object_agg(column1, to_jsonb(t) - 'column1')
from the_table t;
| jsonb_object_agg |
|---|
| {"name 1": {"column2": 0, "column3": 10}, "name 2": {"column2": 0, "column3": 10}, "name 3": {"column2": 0, "column3": 10}} |
SELECT 1