CODE EXAMPLE FOR SQL

postgresql alter column data type from integer to integer array

ALTER TABLE test.test_id
    ALTER COLUMN test_id TYPE INTEGER[]
    USING array[test_id]::INTEGER[];