Andrea, The integer primary column might be going into the sqlite datasource as the FID.
On Sat, Jan 14, 2012 at 1:35 AM, aperi2007 <aperi2...@gmail.com> wrote: > Hi, > > 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 type. > > 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 > > Thx, > > Andrea. > > ______________________________**_________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/**mailman/listinfo/gdal-dev<http://lists.osgeo.org/mailman/listinfo/gdal-dev> > -- Best regards, Chaitanya kumar CH. +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
