Jose, >From our experience -- the SQLite SQL syntax compatibility with PostgreSQL is pretty good, so that your dump idea should more or less work with minor massaging to load into SQLite. Well it will probably work just fine for the regular data if you use the -D insert format of PostgreSQL of pg_dump http://www.postgresonline.com/downloads/special_feature/postgresql83_pg_dump restore_cheatsheet.pdf So the only issue is the geometry output. These will probably not be compatible. You could use pgsql2shp and output using the -w switch which will output to WKT. http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide.bqg That may just work. Haven't tried it myself so good luck and let us know how it turns out. Leo
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Jose Gomez-Dans Sent: Saturday, June 13, 2009 3:44 PM To: PostGIS Users Discussion Subject: [postgis-users] Moving to SpatiaLite: best practice Hi, I'm doing some very simple PostGIS-related work: I store data in a table, and from time to time, I do simple stuff with the stored data, sometimes even actually using the geometry column!!! Anyway, PostGIS has been very useful so far, but I now have to move away from my work computer, and I would like to keep on working with my laptop. One way would be to install PostGIS on my laptop, but I am also thinking of giving my program to other people, who might not necessarily need or want to install PostGIS. To this end, spatialite is very handy. It's just a file, and I can use the same PostGIS stuff I've been using up to now. However, I need to move my tables to SpatialLite. In essence, I do have a number of tables, most of which relate a field to a geographical table. It should be trivial to dump schema and SQL and run it pass sqlite/spatialite. I was just wondering whether anyone had any recommendations or ideas on "best practice". Thanks! Jose
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
