Probably easier to handle in postgres http://stackoverflow.com/a/37538641/461887 select c1[1] as col1, c1[2] as col2, c1[3] as col3, c1[4] as col4, substr(col5, 2) as col5 from ( select string_to_array((string_to_array(the_column, ' '))[1], '-') as c1, (string_to_array(the_column, ' '))[2] as col5 from the_table ) t