Le mercredi 21 décembre 2011 22:02:23, aperi2007 a écrit : > Hi, > I'm try-ing to load a regular table without geometry from a spatialite > to a postgres9.1/postgis 2.0 DB. > > I'm using this sintax: > > ogr2ogr.exe -f "PostgreSQL" PG:"dbname='test' active_schema=gb > schemas=gb,public host='localhost' port='5432' user='postgres' > password='postgres' " -overwrite -lco SCHEMA=gb -lco GEOMETRY_NAME=geom > -lco SPATIAL_INDEX=YES db.sqlite table1 > > where table1 is the table-name on the spatialite db that I like to write > on the PG DB. > > When I try this with the ogr2ogr > > I have this error: > > FAILURE: Couldn't fetch request layer 'table' > > I don't understand where is the bug. > > Perhaps ogr2ogr is unable to load regular table without geometry ?
Not exactly. In a Postgis-enabled DB, the PG driver only lists spatial tables by default. To access to non spatial tables, you need to define the PG_LIST_ALL_TABLES configuration option to YES. See the "Layers" section of http://gdal.org/ogr/drv_pg_advanced.html Ah, and you don't need all those options to specify the schema ! Just active_schema=gb should be enough. > > Thx, > > Andrea Peri > > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
