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

[Hermann Peifer]

On 19/08/2011 15:05, Ingo Weinzierl wrote:
> 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 am not sure if I fully understood the issue, but... what about:

... -sql "select cast(999 as integer(3)) as field from ..."

(If you want an additional integer column with name `field', where all 
values are defined to be 999)

Hermann