postgres where in jsonb code example
Example 1: postgres json
UPDATE users SET data = jsonb_set(data, '{name}', '"John"');Example 2: postgres json
UPDATE users SET tags = tags || array['admin'];UPDATE users SET data = jsonb_set(data, '{name}', '"John"');UPDATE users SET tags = tags || array['admin'];