[gdal-dev] OGR2OGR seem lost the field with primary key . ex
[OGR2OGR seem last ...]
aperi2007 at gmail.com
Sun Jan 15 09:20:32 EST 2012
> The integer primary column might be going into the sqlite datasource
> the FID.
unfortunatelly seem no.
To have a more test I try to export from PG to shapefile.
I can confirm that the integer primary key field is lost in exportation.
I notice also that this happened only if I ask to ogr2ogr to export to
shapefile a full schema.
Instead if I ask to ogr2ogr to export only one table using the -sql
"select * from table_test" , the primary key integer is correctly exported.
Il 14/01/2012 11:59, Chaitanya kumar CH ha scritto:
> The integer primary column might be going into the sqlite datasource as
> the FID.
> On Sat, Jan 14, 2012 at 1:35 AM, aperi2007 <aperi2007 at gmail.com
> <mailto:aperi2007 at gmail.com>> wrote:
> I notice that try-ing exporting from Postgres using ogr2ogr.exe
> It lost completely the primary key filed if that is a integer field.
> Instead it don't lost the same primary key field if it is a varchar
> Is a know bug this ?
> I'm use the gdal 1.9.
> I try exporting to a spatialite or to a shapefile.
> Both report the lost of the field PK.
> The sintax I'm using is this:
> ogr2ogr.exe --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES
> -f "SQLite" prova.sqlite -progress PG:"dbname='test' active_schema=work
> schemas=work host='local' port='5432' user='postgres'
> password='postgres' " -overwrite -lco LAUNDER=yes -dsco SPATIALITE=yes
> -lco SPATIAL_INDEX=yes -gt 65536
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org <mailto:gdal-dev at lists.osgeo.org>
> Best regards,
> Chaitanya kumar CH.
> 17.2416N 80.1426E
More information about the gdal-dev