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

Brice Lambi lambi at ucar.edu
Tue May 11 12:13:40 EDT 2010

You can use 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

More information about the gdal-dev mailing list