update "TAP_SCHEMA".columns set arraysize = replace(arraysize, '*', '') where arraysize like '%*%'; update "TAP_SCHEMA".columns set arraysize = NULL where arraysize = '';