I am trying to load a shapefile into a PostgreSQL/PostGIS databases with the following statement run within the OSGeo4W shell
ogr2ogr -f "PostgreSQL" PG:"host=localhost port=5432 dbname=testing user=postgres password=12345" "D:/TEST_RUBBISH/mains_topo.shp"
I get the following warning which effectively preempts the failure of the insert operation
Warning 1: Geometry to be inserted is of type Multi Line String, whereas the layer geometry type is Line String. Insertion is likely to fail
I have been all over the internet and into the 'PostGIS in Action' book to try and work out how to resolve this but no joy so far
Could anyone out there suggest a solution