Is there a way to merge these in such a way that I could make this from a system call? For example, let's say I want to create this dump file from a Perl or shell script using a system call. Can I do that?
Thanks, Mark On Jan 15, 2008 4:59 PM, Rich Shepard <[EMAIL PROTECTED]> wrote: > 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] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
