On Thu, 12 Jul 2007, Joe Wilson wrote:
The sqlite3 commandline shell has always defaulted to '|' for the separator. You may have been using .mode csv which changes the separator before returning to .mode list:
Joe, Ah, yes. I was exporting rows from tables with mode insert, then reverting to .mode csv to see what I was doing. I've not paid attention to which mode is the default, but your explanation fits my situation. Thanks very much, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------