Changes between Version 4 and Version 5 of SpatiaLite

Timestamp:

Sep 18, 2010, 10:01:17 AM (14 years ago)

Author:

aperi2007

Comment:

—

SpatiaLite

@@ -14 +14 @@
 $ ogr2ogr -f SQLite -update myfile.sqlite b PG:"dbname=mydb user=myuser password=mypass" myschema.my2ndtable
 }}}
+
+To load all the tables of a schema from Postgres to Spatialite (with or without geometry) and without the views:
+{{{
+$ 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
+}}}