I think .mode tabs
does much the same as .separator "\t" but without the ambuguity of single vs double quotes. -Clark ----- Original Message ---- From: "Griggs, Donald" <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, August 13, 2007 2:37:06 PM Subject: RE: [sqlite] Need To Export A Table From a SQLite Database as a TAB Character Delimited Text File Regarding .separator "\t" Vs .separator '\t' Cool. BTW, It seems to require double quotes for me, running Windoze XP, sqlite3.exe version 3.4.0, else the separator becomes literally a backslash followed by the letter t. I'm guessing you're using *NIX and guessing it requires single quotes. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
