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.
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 updated