I have a set of coordinates that come from a kml file and I would like to convert them to wkb for storage in my postgis database. When I use st_geomfromkml, though, I get an error that says I have invalid geometry. The SQL state is XX000.
The error is thrown at the first string.
Here is an example of the coordinates for the linestring: -97.75197377744352 30.52666770876964 0, -97.75203852379295 30.52665828598795 0, -97.75215019046991 30.52664203611576 0.
An additional note, the data type of the column currently holding my coordinates is varchar. I would like to copy them as wkb to my geom column - srid 4326.
How can I convert these to successfully store them in my geom column?