I'm coming from a MySQL background and the mysqldump utility supports schema-only, data-only, and schema plus data dumps. I thought that there was an SQLite trick I was missing somewhere.
Mark On Jan 15, 2008 4:10 PM, Rob Sciuk <[EMAIL PROTECTED]> wrote: > > > 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] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
