I'm going to go with the approach indicated, below. Using .dump didn't work in the sense that .dump does indeed dumpt *only* in "insert into" format.
Thanks, Clark. -----Original Message----- From: Clark Christensen [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 12:26 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? >From the SQLite shell, you can send the output to a file using .output myfile.txt So .output myfile.txt select * from mytable; .output stdout will get you a pipe-delimited myfile.txt. You can change the delimiter using the .separator command, or you can use .mode to use a predefined format. -Clark ----- Original Message ---- From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, March 9, 2007 9:04:29 AM Subject: [sqlite] Is there an inverse for .import? I need to "export" a table to a file in the same format as used by .import, but I don't see any such cmd. Am I missing something, or does such a cmd just not exist? jim ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
