By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| product | jsonb_object_agg |
|---|---|
| A | {"price": "4.00", "category": "food"} |
| B | {"genre": "Sci-Fi", "price": "20.00", "category": "book"} |
SELECT 2
| product | jsonb_object_agg |
|---|---|
| A | {"price": "4.00", "category": "food"} |
| B | {"genre": "Sci-Fi", "price": "20.00", "category": "book"} |
SELECT 2