[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