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

[Ingo Weinzierl]

Hi Hermann,

On Mon, Aug 22, 2011 at 01:30:00PM +0200, Hermann Peifer wrote:
> On 22/08/2011 13:13, Ingo Weinzierl wrote:
> >Hi *,
> >
> >I already tried the approach below - without success. The result of
> >my operation is:
> >
> >The command:
> >------------
> >     ogr2ogr -f "ESRI Shapefile" -sql "SELECT cast(999 as integer(3)) as
> >       river_id from SRCShape" DESTShape.shp SRCShape.shp
> >
> >The command's result:
> >---------------------
> >     ERROR 1: SQL: Unrecognised field name 999
> >
> >
> 
> What does ogr2ogr --version say? On my side, it says:
> GDAL 1.9dev, released 2011/01/18
> 
> BTW: you could drop `-f "ESRI Shapefile"', as it is the default.

It says "GDAL 1.6.3, released 2009/11/19". This version comes along
with Debian Squeeze.

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