postgresql jsonb_set 更改json数据

假如有个表存储的json数据如下

{"name":"ss","age":100,"die":true}

想更改name，使用以下sql，注意需要条件引号

select jsonb_set(jsontest ,'{name}','"t5t"') from tt where id =5

假如json 如下

[
    {
        "model": "core.location",
        "pk": 119,
        "fields": {
            "name": "Vista Community Clinic- The Gary Center, S. Harbour Blvd",
            "full_address": "201 S. Harbor Boulevard, \nLa Habra, CA 90631"
        }
    }
]

修改name sql如下

update tt set jsontest = jsonb_set(jsontest,'{0,fields,name}','"test"')  where id=2