Skip to content

Update json[]/jsonb[] in PostgreSQL

UPDATE TableName SET FIELD = ARRAY[ jsonb_build_object('letter', 'A', 'count', 0), jsonb_build_object('letter', 'B', 'count', 0) ]::jsonb[]