Changes between Version 11 and Version 12 of SpatiaLite

Timestamp:

Jan 15, 2012, 7:24:30 AM (12 years ago)

Author:

aperi2007

Comment:

—

SpatiaLite

@@ -20 +20 @@
 $ ogr2ogr --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=yes -gt 65536 -gt
+  -dsco SPATIALITE=yes -lco SPATIAL_INDEX=yes -gt 65536
 }}}
 Some advertising: To avoid the lost of the third dimension exporting geometries you need use almost gdal 1.9.0 and spatialite library 3.0.0.[[BR]]
@@ -26 +26 @@
 of type TEXT that are also primary keys. To avoid this lost you should use the "single table" call.
 
+[[BR]]
+To load a table (mytable) (with a geometry columns named "geometry") from a Sqlite/Spatialite (mysqlite.sqlite) into a schema (myschema) of a Postgres/Postgis, using gdal 1.9.0 and spatialite 3.0.0:[[BR]]
+
+{{{
+ogr2ogr --config SQLITE_LIST_ALL_TABLES YES -f "PostgreSQL" PG:"dbname='mydb' active_schema=myschema schemas=myschema host='localhost' port='5432' user='myuser' password='mypass' " -overwrite -lco SCHEMA=myschema -lco GEOMETRY_NAME=geometry -lco SPATIAL_INDEX=YES mysqlite.sqlite  mytable
+}}}
+