On Thu, 3 Feb 2011, Ewan, Michael wrote:
> The quotes should not be in the data. One of the "features" of COPY is
> that the input is delimited so you don't need quotes, at least that is my
> experience. I'll send you a sample script I wrote that creates a COPY
> script that can be run directly from the command line. Give me a few
> minutes to get back to my desk.
Ah, so! I've been using SQLite3 the past couple of years embedded in my
models and columns are flexible in the data they accept.
So, when I export the data from the spreadsheets I should either not
define a text quote or remove them in emacs before I COPY them into the
This is highly valuable information!
In response to
pdxpug by date
|Next:||From: Rich Shepard||Date: 2011-02-03 18:42:17|
|Subject: More Cleanup Guidance Needed|
|Previous:||From: Ewan, Michael||Date: 2011-02-03 18:31:23|
|Subject: Re: Syntax Error?|