Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t( json_data JSONB )

CREATE TABLE


INSERT INTO t
VALUES('[
        {
          "id": "c75e7a-001e-4d64-9613-62f666d42103",
          "name": "Product1"
        },
        {
          "id": "c75e7a-001e-4d64-9613-62f666d42103",
          "name": null
        },
        {
          "id": "c75e7a-001e-4d64-9613-62f666d42103",
          "name": "Product2"
        },
        {
          "id": "c75e7a-001e-4d64-9613-62f666d42103",
          "name": null
        }
]')

INSERT 0 1


SELECT JSONB_PRETTY(
                    JSONB_AGG(j)
                   )
  FROM t, 
       JSONB_ARRAY_ELEMENTS(json_data) AS j
 WHERE j.value ->> 'name' IS NOT NULL
 GROUP BY json_data


jsonb_pretty


[
    {
        "id": "c75e7a-001e-4d64-9613-62f666d42103",
        "name": "Product1"
    },
    {
        "id": "c75e7a-001e-4d64-9613-62f666d42103",
        "name": "Product2"
    }
]



SELECT 1


WITH tt AS
(
SELECT JSONB_AGG(j) AS new_val,
       json_data            
  FROM t, 
       JSONB_ARRAY_ELEMENTS(json_data) AS j
 WHERE j.value ->> 'name' IS NOT NULL
 GROUP BY json_data
)
UPDATE t
   SET json_data = new_val::JSONB
  FROM tt
 WHERE t.json_data = tt.json_data

UPDATE 1


SELECT JSONB_PRETTY(json_data)
  FROM t


jsonb_pretty


[
    {
        "id": "c75e7a-001e-4d64-9613-62f666d42103",
        "name": "Product1"
    },
    {
        "id": "c75e7a-001e-4d64-9613-62f666d42103",
        "name": "Product2"
    }
]



SELECT 1