Skip site navigation (1) Skip section navigation (2)

Re: Syntax Error?

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pdxpug(at)postgresql(dot)org" <pdxpug(at)postgresql(dot)org>
Subject: Re: Syntax Error?
Date: 2011-02-03 18:38:58
Message-ID: alpine.LNX.2.00.1102031036420.25032@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
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
table.

This is highly valuable information!

Rich

In response to

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-03 18:42:17
Subject: More Cleanup Guidance Needed
Previous:From: Ewan, MichaelDate: 2011-02-03 18:31:23
Subject: Re: Syntax Error?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group