http://www.gaia-gis.it/OpenLite/ ogr2ogr from gdal.org can probably do it on the command line Spatialite I think has a Virtual Postgres table tool too. (You can probably ignore that these are mostly for spatial data, should work fine on regular tables)
Honestly a small python script to read from sqlite and insert to Postgres is quite simple, especially if the schema in Postgres already matches. Open Sqlite connection Open Postgres connection Query Sqlite table Prepare statement insert to postgres Close Connections I would encourage you to keep your working copy in Postgres and use your SQLite files as archives. Enjoy, Alex On 09/25/2013 11:44 PM, Vivien Malerba wrote: > Hi! > > Using Libgda (http://www.gnome-db.org) you can create virtual connections > which "aggregate" several other connections (meaning all the tables from > all the connections can be used in single SQL queries and you could copy > data using an "INSERT INTO XXX SELECT ... FROM YYY" query), in your case > you could aggregate a PostgreSQL and a SQLite connection. > > Hope it helps, > Regards > Vivien > > > On 25 September 2013 18:45, [email protected] < > [email protected]> wrote: > >> Looking for a solution to connect directly from a PostgreSQL database to a >> SQLite database. We need PostgreSQL for it's Window/Analytic functions and >> other features that SQLite doesn't have. Yet, SQLite is great for >> collecting data. >> >> Every one of our experiments adds 300MB to the SQLite database. Rather >> than exporting to CSV and then importing to PostgreSQL, we'd like to >> directly access SQLite from PostgreSQL. >> >> Does anyone have good experience using 'Foreign Data Wrapper for sqlite' >> or another method? >> https://github.com/gleu/**sqlite_fdw <https://github.com/gleu/sqlite_fdw> >> >> >> Joe Fisher >> Oregon State University >> >> ______________________________**_________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
