SQL · JSON functions

jsonb functions

Binary JSON storage and update helpers. PostgreSQL only.

sqlRunnable example sql course

Syntax

jsonb_set(jsonb, path, value)

Example

Open in the lab

-- PostgreSQL
-- SELECT jsonb_set('{"a":1}'::jsonb, '{b}', '2');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.