[gdal-dev] OGR2OGR seem lost the field with primary key . ex [OGR2OGR seem last ...]

Chaitanya kumar CH chaitanya.ch at gmail.com
Sat Jan 14 05:59:46 EST 2012


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 <aperi2007 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120114/c7e40850/attachment.html


More information about the gdal-dev mailing list