Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table my_table as select jsonb '{
  "id": 1,
  "foo": "bar",
  "something": "anything",
  "something_else": "anything_else",
  "video": [
    {
      "id": 1,
      "type": "slow",
      "width": 700,
      "height": 900
    },
    {
      "id": 2,
      "type": "medium",
      "width": 900,
      "height": 100
    },
    {
      "id": 3,
      "type": "fast",
      "width": 700,
      "height": 900
    }
  ],
  "image": {
    "candidates": [
      {
        "width": 480,
        "height": 600,
        "scans_profile": "e35"
      },
      {
        "width": 480,
        "height": 600,
        "scans_profile": "e35"
      }
    ]
  }
}' as my_json_column,
jsonb '{
  "id": 1,
  "foo": "bar",
  "video": [
    {
      "id": 1,
      "width": 700,
      "height": 900
    },
    {
      "id": 2,
      "width": 900,
      "height": 100
    },
    {
      "id": 3,
      "width": 700,
      "height": 900
    }
  ],
  "image": {
    "candidates": [
      {
        "scans_profile": "e35"
      },
      {
        "scans_profile": "e35"
      }
    ]
  }
}' my_expected_json_column

1 rows affected

my_new_json_column
{"id": 1, "foo": "bar", "image": {"candidates": [{"scans_profile": "e35"}, {"scans_profile": "e35"}]}, "video": [{"id": 1, "width": 700, "height": 900}, {"id": 2, "width": 900, "height": 100}, {"id": 3, "width": 700, "height": 900}]}