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

[Hermann Peifer]

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.

Hermann