On 1/15/08, Mark Riehl <[EMAIL PROTECTED]> wrote: > I'm coming from a MySQL background and the mysqldump utility supports > schema-only,
sqlite> .mode filename sqlite> .s > data-only, sqlite> .mode filename sqlite> .mode csv|tabs sqlite> .dump > and schema plus data dumps. sqlite> .mode filename sqlite> .mode insert sqlite> .dump > 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 > > > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
