On Wed, 9 Jun 2010, Vivien Malerba wrote: >> I forgot to mention, the source is a PostgreSQL db, not SQLite, so >> there's no source file to copy. Though a backup might be >> interesting ...
> You can use Libgda's gda-sql tool in which you can: > * open a connection to the PostgreSQL db (for example named db1) > * open a connection to the SQLite db (for example named db2) > * bind those 2 connections into a 3rd one, and execute statements like > "insert into db2.table_one_name select * from db1.table_one_name ;" Why not do a database dump from postgres, then read the .sql file into SQlite? As long as you use standard SQL in the data development language (DDL) you'll get ASCII SQL files for each table's schema with INSERT statements for each row of each table. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users