Postgresql: Modify one value inside of a nested json column
You are looking for jsonb_set()
update &quot;Assets&quot; 
  set &quot;Parameters&quot; = jsonb_set(&quot;Parameters&quot;::jsonb, '{params2, k}', to_jsonb(2.2))
where ...