Export from posgis to spatialite?

Question

My postgis database contains osm data from my country. For transportation reasons i want to export a spatial view i created from those data to an spatialite database.

Is there any way to directly extract my postgis view to a spatialite db without resorting to a man-in-the-middle (shapefile then sqlite) solution?

Im using ubuntu linux, with postgis 2.1 gdal 191

EDIT:

here's a single cmd to expot to shapefile:

ogr2ogr -f "ESRI Shapefile" <name-of-folder-to-be-created> \
PG:"dbname=dbname user=username password=pass" \
-sql "<sql query eg> select * from database where <whatever>"

If you get a getsrid(geom) error, load in your database the "legacy.sql"

psql -f /path/to/legacy.sql

Answer 1

ogr2ogr?

See here for more information and maybe here as well

Cheers

Stéphane

Answer 2

If you haven't done a lot of work in postgis, another alternative might be to import it directly from OSM into spatialite.