Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7F7B49FA170 for ; Thu, 25 Oct 2007 16:13:58 -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 47412-08 for ; Thu, 25 Oct 2007 16:13:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from k2smtpout04-02.prod.mesa1.secureserver.net (k2smtpout04-02.prod.mesa1.secureserver.net [64.202.189.173]) by postgresql.org (Postfix) with SMTP id B169B9FA394 for ; Thu, 25 Oct 2007 16:13:54 -0300 (ADT) Received: (qmail 18822 invoked from network); 25 Oct 2007 19:13:53 -0000 Received: from unknown (HELO mail.servantwebhosting.com) (68.178.159.82) by k2smtpout04-02.prod.mesa1.secureserver.net (64.202.189.173) with ESMTP; 25 Oct 2007 19:13:53 -0000 Received: (qmail 7884 invoked from network); 25 Oct 2007 12:13:52 -0700 Received: from s010600e0296eec95.mj.shawcable.net (HELO shach) (rob@nullmx.com@70.64.195.140) by mail.servantwebhosting.com with SMTP; 25 Oct 2007 12:13:52 -0700 From: "Chuck D." Reply-To: pgsql-list@nullmx.com To: pgsql-sql@postgresql.org Subject: Re: request for help with COPY syntax Date: Thu, 25 Oct 2007 13:13:46 -0600 User-Agent: KMail/1.9.6 References: <200710251016.01844.pgsql-list@nullmx.com> <4720CB0D.4050403@presinet.com> In-Reply-To: <4720CB0D.4050403@presinet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200710251313.47075.pgsql-list@nullmx.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/123 X-Sequence-Number: 29495 On October 25, 2007 10:57:49 am you wrote: > > If all you just want to do is strip out the ^M, you can run dos2unix on > it, assuming that you are running a *nix distro. Well, I guess I could strip the ^M but I'm still left with a $ in the middle of a field which in the same as the line terminator, so COPY thinks it is at the end of a line when it is really in the middle of the field. I really wish they would have quoted these fields, but I'm at a loss how to import these.