Changes between Version 7 and Version 8 of SpatiaLite


Ignore:
Timestamp:
Jan 15, 2012, 7:12:57 AM (10 years ago)
Author:
aperi2007
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • SpatiaLite

    v7 v8  
    1616
    1717To load all the tables of a schema from Postgres to Spatialite (with or without geometry) and without the views:
     18
    1819{{{
    1920$ ogr2ogr --config PG_LIST_ALL_TABLES YES --config PG_SKIP_VIEWS YES -f "SQLite" mydb.sqlite -progress PG:"dbname='mydb' \
    2021  active_schema=myschema schemas=myschema host='localhost' port='5432' user='myuser' password='mypass' " -lco LAUNDER=yes \
    21   -dsco SPATIALITE=yes -lco SPATIAL_INDEX=no
     22  -dsco SPATIALITE=yes -lco SPATIAL_INDEX=yes -gt 65536 -gt
    2223}}}
     24This sintax need almost gdal 1.9.0 and spatialite 3.0.0 to avoid lost the 3rd dimension exporting the geometries.[[BR]]
     25Another point is the primary keys: The exportation of a full schema lost every primary key of integer type (don't lost the textual primary keys).[[BR]]
     26To avoid this lost you should use the "single table" call.
     27