merging many jsonb objects using aggregate functions in PostgreSQL?
8
votes
2
answers
5897
views
Is there a standard function in PostgreSQL (as of 12.x) to concatenate or merge many jsonb objects in a database column into a single jsonb object?
I know there is a the || operator since PostgreSQL 9.5 to merge **two** jsonb objects. But I need to merge many jsonb objects from a column. The linked documentation does not seem to have one unless I am missing something.
Asked by tinlyx
(3820 rep)
Dec 8, 2019, 06:14 PM
Last activity: Mar 5, 2025, 01:32 AM
Last activity: Mar 5, 2025, 01:32 AM