[gdal-dev] Convert shapefile to SQL text for PostGIS

[Brice Lambi]

You can use shp2text:

http://www.obviously.com/gis/shp2text/

It won't output the insert statements directly but it will create a tab
delimited file that you could then parse into your database.



Aleksey Naumov wrote:
> Dear GDAL users,
> 
> Is there a way to use ogr2ogr or other means to convert a layer (e.g. a
> shapefile) into an SQL text file suitable for insertion into PostGIS? In
> other words, a file with SQL text like:
> 
> INSERT INTO "my_table" ("the_geom" ) VALUES
> (GeomFromEWKT('SRID=-1;POLYGON (( ...))'::TEXT) );
> 
> which could be read into PostgreSQL later. Ideally, I am looking for a
> direct conversion, i.e. not involving PostGIS.
> 
> Thank you,
> Aleksey
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev