The ST_PointFromKML() function

The ST_PointFromKML() function takes a KML Point string and an optional spatial reference ID and returns a point object. A Point string can contain the elements of <coordinates>, <extrude>, <tessellate>, and <altitudeMode>.

Syntax

ST_PointFromKML(kmlstring lvarchar)
ST_PointFromKML(kmlstring lvarchar, SRID integer)

Return type

ST_Point

Example

EXECUTE FUNCTION ST_PointFromKML('<Point><coordinates>-122.44255879,37.80666418
                </coordinates></Point>',3);
Output: 
   3 POINT (-122.44255879 37.80666418)