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: (view raw, whole thread or download thread mbox)
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

This is highly valuable information!


In response to


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-2017 The PostgreSQL Global Development Group