Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: request for help with COPY syntax
- From: "Chuck D." <pgsql-list(at)nullmx(dot)com>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Re: request for help with COPY syntax
- Date: Thu, 25 Oct 2007 13:13:46 -0600
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.
- Follow-Ups:
- Re: request for help with COPY syntax
- From: Fernando Hevia
- Re: request for help with COPY syntax
- References:
- Re: request for help with COPY syntax
- From: Chuck D.
- Re: request for help with COPY syntax
- From: Bricklen Anderson
- Re: request for help with COPY syntax
- Prev by Date: JOINing based on whether an IP address is contained within a CIDR range?
- Next by Date: Re: JOINing based on whether an IP address is contained within a CIDR range?
- Previous by thread: Re: request for help with COPY syntax
- Next by thread: Re: request for help with COPY syntax
- Indexes: