[gdal-dev] How to load a regular table from splite to postgres
aperi2007
aperi2007 at gmail.com
Wed Dec 21 16:02:23 EST 2011
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 ?
Thx,
Andrea Peri
More information about the gdal-dev
mailing list