= SpatiaLite = [http://www.gaia-gis.it/spatialite/ SpatiaLite] is a relatively new GIS file format based on [http://www.sqlite.org/ SQLite], which uses a single file to store multiple layers and data tables. It is an alternative format to ESRI Shapefiles, which have several legacy issues (such as storage types and lengths of column names, etc.) Furthermore it is simple to distribute and run, as there is only one file. == Exporting from PostGIS to SpatiaLite == Use [http://www.gdal.org/ogr2ogr.html ogr2ogr] built with [http://www.gdal.org/ogr/drv_sqlite.html SpatiaLite options]. To create the SpatiaLite file and export the first layer: {{{ $ ogr2ogr -f SQLite -dsco SPATIALITE=yes myfile.sqlite PG:"dbname=mydb user=myuser password=mypass" myschema.mytable }}} And for additional layer/tables: {{{ $ ogr2ogr -f SQLite -update myfile.sqlite b PG:"dbname=mydb user=myuser password=mypass" myschema.my2ndtable }}}