Jsonb Index Page 1

PostgreSQL: Update query for JSONB columns with examples

PostgreSQL 9.5 added the type JSONB, which supports json as datatype. Here we show an example on how to perform an UPDATE on a jsonb type using postgresql. If you want to override the whole dict, just send the json between single quotes. check here for some example queries.