Re: [gdal-dev] Dump Shapefile into DB using ogr2ogr

2011-08-19 Thread Chaitanya kumar CH
Ingo, By default a Feature ID column is entered into the database regardless of the fields. No duplicates or null values. Perhaps you might want to modify this column. On Fri, Aug 19, 2011 at 6:35 PM, Ingo Weinzierl < ingo.weinzi...@intevation.de> wrote: > Thanks for the quick reply, but the "-s

Re: [gdal-dev] Dump Shapefile into DB using ogr2ogr

2011-08-19 Thread Ingo Weinzierl
Thanks for the quick reply, but the "-select" option only solves one of the two parts of my problem. I still need to append a further column that does not exist in the shapefile and which should be defined manually. I already played a while with VRT files. I tried to define a node for each column

Re: [gdal-dev] Dump Shapefile into DB using ogr2ogr

2011-08-18 Thread Chaitanya kumar CH
Ingo, Use the -select option with an empty string in ogr2ogr [1]. ogr2ogr -select "" dest.shp src.shp [1]: http://www.gdal.org/ogr2ogr.html On Thu, Aug 18, 2011 at 3:53 PM, Ingo Weinzierl < ingo.weinzi...@intevation.de> wrote: > Hello GDAL community, > > I have already used GDAL to get informat

[gdal-dev] Dump Shapefile into DB using ogr2ogr

2011-08-18 Thread Ingo Weinzierl
Hello GDAL community, I have already used GDAL to get information about shapefiles or to insert a shapefile into a database. So, many thanks to all of you! Now, I've just tried to dump a shapefile into an existing table of a spatial database (PostGIS / Oracle) using ogr2ogr. Therefore, I need som