From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: request for help with COPY syntax
Date: Tue, 23 Oct 2007 12:46:38 -0400
Message-ID: <20071023164638.GI26559@crankycanuck.ca> (raw)
In-Reply-To: <200710231019.07833.pgsql-list@nullmx.com>
References: <200710231019.07833.pgsql-list@nullmx.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: request for help with COPY syntax
In-Reply-To: <20071023164638.GI26559@crankycanuck.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox