>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: [email protected] 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] -----------------------------------------------------------------------------
