Re: request for help with COPY syntax - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: request for help with COPY syntax
Date
Msg-id 20071023164638.GI26559@crankycanuck.ca
Whole thread Raw
In response to request for help with COPY syntax  ("Chuck D." <pgsql-list@nullmx.com>)
List pgsql-sql
On Tue, Oct 23, 2007 at 10:19:07AM -0600, Chuck D. wrote:
> by,kruhavyetskalini"na,KruhavyetsKalini"na,02,52.1438889,31.6925
> 
> There are a couple " where I would expect to see ' instead.  I see other lines 
> in the data that use both in a field.

Ugh.  I think I would normalise the data before COPYing, myself. This
is a generally good practice for importing data: too much
intelligence in the import stage itself can cause unexpected side
effects and debugging pain.  Better to put an extra step in that
ensures the data is all marked up consistently on the way into the
import step.

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.    --H.W. Fowler


pgsql-sql by date:

Previous
From: "Chuck D."
Date:
Subject: request for help with COPY syntax
Next
From: "Fernando Hevia"
Date:
Subject: Re: request for help with COPY syntax