On Tue, 15 Jan 2008, Mark Riehl wrote:
Is there a way to dump out the contents of the database w/o having the CREATE TABLE statements? For example, I can do the following: sqlite3 foo.db .dump > foo.dmp However, foo.dmp contains all of the CREATE TABLE statements. I just want all of the INSERT INTO statements associated with this database. I looked through the documentation but didn't find the answer to this one, I apologize if it's already in the docs. Thanks, Mark
Actually, this looks like a reasonable enhancement request. As it does *NOT* affect the API in any way, and PostGres allows separate schema and data dumps (the default being both) in psql, there should be no reason not to put it into the sqlite3 tool, unless I'm missing something?? Am I?
Cheers, Rob Sciuk ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------