On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote: > >> What's the best way to copy data from one db to another? >> >> Given 2 databases with identical schemas, one full of data and the >> other empty, the brute force way would be to perform selects on the >> source db, then for each row, perform an insert into the destination >> db. Is there a more efficient way? > > The easiest is either to simply copy the file as Igor suggested or use > the backup API (very easy too).
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 ... > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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
