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, joe.fis...@tanguaylab.com < joe.fis...@tanguaylab.com> 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users