Changes between Version 4 and Version 5 of SpatiaLite


Ignore:
Timestamp:
Sep 18, 2010, 10:01:17 AM (12 years ago)
Author:
aperi2007
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • SpatiaLite

    v4 v5  
    1414$ ogr2ogr -f SQLite -update myfile.sqlite b PG:"dbname=mydb user=myuser password=mypass" myschema.my2ndtable
    1515}}}
     16
     17To load all the tables of a schema from Postgres to Spatialite (with or without geometry) and without the views:
     18{{{
     19$ ogr2ogr.exe --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES -f "SQLite" mydb.sqlite -progress PG:"dbname='mydb' active_schema=myschema schemas=myschema host='localhost' port='5432' user='myuser' password='mypass' " -lco LAUNDER=yes -dsco SPATIALITE=yes -lco SPATIAL_INDEX=no
     20}}}