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

From Chuck D.
Subject Re: request for help with COPY syntax
Date
Msg-id 200710251313.47075.pgsql-list@nullmx.com
Whole thread Raw
In response to Re: request for help with COPY syntax  (Bricklen Anderson <banderson@presinet.com>)
Responses Re: request for help with COPY syntax
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: "Jamie Tufnell"
Date:
Subject: JOINing based on whether an IP address is contained within a CIDR range?
Next
From: Erik Jones
Date:
Subject: Re: JOINing based on whether an IP address is contained within a CIDR range?