如何在JSON列Postgres中附加到嵌套数组

Question

我的列具有下一个结构：

 {
  "_id": "57101c4efbea42d219e068b3",
  "name": "System admin group",
  "is_service": 0,
  "security_lists": {
    "actions": [
      "ota upload",
      "widgets manage",
      "scheduled jobs manage all",
      "users view"
    ]
  }
}

如何将值附加到操作数组中？ 我想可以使用JSONB_SET（）完成它，但是我不知道该怎么做（

Answer 1

    UPDATE 
        group_permissions 
    SET 
        "document"=jsonb_set("document"::jsonb, 
        '{security_lists, actions}', 
        ("document" ->'security_lists'->'actions')::jsonb || 
        '["newString"]'::jsonb) 
    WHERE 
        "document"::json->>'name'='System admin group';