postgresqlのjsonbデータの問い合わせと変更方法

# The data stored is in key-value format, and the corresponding value is obtained by specifying the key
# Use -> to return the result with quotes
select '{"nickname": "goodspeed", "avatar": "avatar_url"}'::json->'nickname' as nickname;
# Use ->> to return results without quotes
select '{"nickname": "goodspeed", "avatar": "avatar_url", "tags": ["python", "golang", "db"]}'::json->>'nickname' as nickname;

# {tags,0} means query key='tags' and value is the first element of the array in the array
select '{"nickname": "gs", "avatar": "avatar_url", "tags": ["python", " golang", "db"]}'::json#>'{tags,0}' as tag;
# {aa,b,0} represents the query key='aa', corresponding to the first element of the array in the value of key='b'
select '{"nickname": "gs", "avatar": "avatar_url", "tags": ["python", " golang", "db"], "aa":{"b": [{"c": 1}]}}'::jsonb#>>'{aa,b,0}';

jsonb_set(original data, position to be changed, value to replace, whether to add if it doesn't exist), 
select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0,f1}', '[2,3,4]', false);