Andrea,<div><br></div><div>The integer primary column might be going into the sqlite datasource as the FID.<br><br><div class="gmail_quote">On Sat, Jan 14, 2012 at 1:35 AM, aperi2007 <span dir="ltr"><<a href="mailto:aperi2007@gmail.com">aperi2007@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
I notice that try-ing exporting from Postgres using ogr2ogr.exe<br>
It lost completely the primary key filed if that is a integer field.<br>
Instead it don't lost the same primary key field if it is a varchar type.<br>
<br>
Is a know bug this ?<br>
<br>
I'm use the gdal 1.9.<br>
<br>
I try exporting to a spatialite or to a shapefile.<br>
Both report the lost of the field PK.<br>
<br>
The sintax I'm using is this:<br>
<br>
ogr2ogr.exe --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES<br>
-f "SQLite" prova.sqlite -progress PG:"dbname='test' active_schema=work<br>
schemas=work host='local' port='5432' user='postgres'<br>
password='postgres' " -overwrite -lco LAUNDER=yes -dsco SPATIALITE=yes<br>
-lco SPATIAL_INDEX=yes -gt 65536<br>
<br>
Thx,<br>
<br>
Andrea.<br>
<br>
______________________________<u></u>_________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Best regards,<br>Chaitanya kumar CH.<br><br>+91-9494447584<br>17.2416N 80.1426E<br>
</div>