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 <Field> node for each column I want to insert into my database - without any success...
Regards, Ingo On Thu, Aug 18, 2011 at 05:00:58PM +0530, Chaitanya kumar CH wrote: > 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 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 > > some help: > > > > The only thing of the shapefile I need is the geometry column, but > > the database schema requires a further Integer column (NOT NULL > > constraint). In my use-case, I would like to define this Integer > > value manually while calling ogr2ogr. Therefore, I've already > > searched for some VRT examples, with no success. > > > > In simple words: I want to insert the geometry column (shapefile) > > and an Integer value (manually defined) into a pre-defined spatial > > database (PostGIS / Oracle). > > > > I would be glad if someone could give me some hints how to realize > > such a ogr2ogr call. > > > > Regards, Ingo > > -- > > Ingo Weinzierl | ++49-541-335083-0 | OpenPGP key: 0x2D2E2573 > > Intevation GmbH, Neuer Graben 17, 49074 Osnabrück | AG Osnabrück, HR B > > 18998 > > Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner > > _______________________________________________ > > gdal-dev mailing list > > gdal-dev@lists.osgeo.org > > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > > > -- > Best regards, > Chaitanya kumar CH. > > +91-9494447584 > 17.2416N 80.1426E -- Ingo Weinzierl | ++49-541-335083-0 | OpenPGP key: 0x2D2E2573 Intevation GmbH, Neuer Graben 17, 49074 Osnabrück | AG Osnabrück, HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev