On Tue, 15 Jan 2008, Rob Sciuk 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:
However, foo.dmp contains all of the CREATE TABLE statements. I just want all of the INSERT INTO statements associated with this database.
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?
Not needed; it already exists. Change the mode to 'insert', select a file name for your output, then run the select statement. For example: sqlite> .m insert sqlite> .o table-values.sql sqlite> Select * from Tablename; sqlite> .o stdout sqlite> .m list The last two commands reset the output and mode back to the interactive values. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
