convert to jsonobject in postgresql code example
Example 1: json array to string in postgresql
SELECT string_agg(trim(tdata::text, '"'), ', ') from jsonb_array_elements(CAST('[1 , 2]' as jsonb)) tdata
Example 2: postgres json
UPDATE users SET tags = tags || array['admin'];