postgres add object to jsonb array from the same column
We want to create a new column where it's a combination for several column as a jsonb object.
1
ALTER TABLE items
2
ADD new_arrays_col jsonb DEFAULT '[]';
3
​
4
UPDATE items i1
5
SET new_arrays_col = new_arrays_col || JSON_BUILD_OBJECT(
6
'col1', col1,
7
'col1', col2
8
)::jsonb
Copied!
the new_arrays || ... is kind of like appending to exisitng array with an object. JSON_BUILD_OBJECT is a postgres function to create a JSON object from the parameters
Last modified 6mo ago
Copy link