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 list (firstname text,lastname text,age integer);
CREATE TABLE
insert into list
values
('SHARON','XAVIER',25),
('RON','PETER',17),
('KIM','BENNY',14);
INSERT 0 3
select jsonb_agg(to_jsonb(l))
from list l;
| jsonb_agg |
|---|
| [{"age": 25, "lastname": "XAVIER", "firstname": "SHARON"}, {"age": 17, "lastname": "PETER", "firstname": "RON"}, {"age": 14, "lastname": "BENNY", "firstname": "KIM"}] |
SELECT 1