By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Rows matched: 1 Changed: 1 Warnings: 0
| id | json_column |
|---|---|
| 1 | [{"Name": "Number", "Id": "PhoneNumber", "Value": "+393123456789"}, {"Name": "Name", "Id": "FirstName", "Value": "John"}, {"Name": "City", "Id": "CityID", "Value": "CALI"}] |