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
No, there is no way to do this in sqlite3. The .dump command is
intended to produce a complete set of SQL statements that, when
executed, will recreate the database being dumped.
Can't you just remove the CREATE TABLE statements manually, or
pipe the output of .dump to sed or awk?
Regards,
- Richard Klein
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
