Re: [gdal-dev] Export from PG to spatialite

2011-12-31 Thread aperi2007
> driver, but not of the SQLite driver. The SQLite driver has a hardcode name > for the geometry column, which is GEOMETRY Hi, Roualt , this is really clear and precious information for me. Expecially the info on the hardcoded name in splite. This was not really clear in the docs for sqlite/s

Re: [gdal-dev] Export from PG to spatialite

2011-12-31 Thread Even Rouault
Le samedi 31 décembre 2011 13:18:54, vous avez écrit : > Hi, > > I'm try to export from Postgres 9.1.2 with Postgis 2.0 to a spatialite > 3.0.0 version using ogr2ogr.exe. > To do this I try this sintax: > > ogr2ogr.exe --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES > -f "SQLite" db.sq

[gdal-dev] Export from PG to spatialite

2011-12-31 Thread aperi2007
Hi, I'm try to export from Postgres 9.1.2 with Postgis 2.0 to a spatialite 3.0.0 version using ogr2ogr.exe. To do this I try this sintax: ogr2ogr.exe --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES -f "SQLite" db.sqlite -progress PG:"dbname='test' active_schema=work schemas=work,p