select string_to_array(your_column, ' ')
from your_table;

alter table your_table
      alter your_column data text[] using string_to_array(your_column, ' ');