sql: transfrom data to table

array to table

select
  survey_id
from
  (
    select
      UNNEST(regexp_split_to_array('1,2,4', ','))
  ) as dt(survey_id)

note: seems the dt(survey_id) is required.