[postgis-users] KML to PostGIS

[Olivier Courtin]

On Oct 4, 2010, at 2:09 PM, Paulo Angelo wrote:

Hi Paulo,

> How can I convert a KML file to PostGIS?

If you need to convert a KML geometry fragment, you could use
native ST_GeomFromKML function. (since PostGIS 1.5)
http://postgis.refractions.net/docs/ST_GeomFromKML.html

And if you need to convert a whole KML document,
consider ogr2ogr from GDAL.
http://www.gdal.org/ogr/drv_kml.html

HTH,

--
Olivier