Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5E5019FC6ED for ; Tue, 23 Oct 2007 13:46:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 74341-01-5 for ; Tue, 23 Oct 2007 13:46:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 698609FC718 for ; Tue, 23 Oct 2007 13:46:44 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IkMtv-0007nZ-Nw for pgsql-sql@postgresql.org; Tue, 23 Oct 2007 12:46:43 -0400 Received: by crankycanuck.ca (Postfix, from userid 1000) id 61A7E3FAF; Tue, 23 Oct 2007 12:46:38 -0400 (EDT) Date: Tue, 23 Oct 2007 12:46:38 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: request for help with COPY syntax Message-ID: <20071023164638.GI26559@crankycanuck.ca> References: <200710231019.07833.pgsql-list@nullmx.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200710231019.07833.pgsql-list@nullmx.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/91 X-Sequence-Number: 29463 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