Split of a coordinate field
SELECT st_astext(st_geomfromtext('POINT(' || split_part(txt_coords, ' ', 1) || ' ' || split_part(txt_coords, ' ', 2) || ')', 4258)) FROM tablatxt;
SELECT st_astext(st_geomfromtext('POINT(' || split_part(txt_coords, ' ', 1) || ' ' || split_part(txt_coords, ' ', 2) || ')', 4258)) FROM tablatxt;