::json in postgres 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'];