Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: request for help with COPY syntax
- From: Bricklen Anderson <banderson(at)presinet(dot)com>
- To: pgsql-list(at)nullmx(dot)com
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: request for help with COPY syntax
- Date: Thu, 25 Oct 2007 09:57:49 -0700
- Message-id: <4720CB0D.4050403@presinet.com> <text/plain>
Chuck D. wrote:
Pardon me on this, the cat -A report for the failed line (and subsequent lines) shows ^M$ within the field, not just $.I assume that is probably a \r\n and postgres wants \r for field data and \n to end a line.I've tried working this over with sed but can't get the syntax right. I also have iconv installed if that would help any. Are there any good tools that will tell me what this really is instead of just ^M$ ?
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.
- Follow-Ups:
- Re: request for help with COPY syntax
- From: Chuck D.
- 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
- Prev by Date: (repost) Help understanding expressions in order by clause
- Next by Date: Re: (repost) Help understanding expressions in order by clause
- Previous by thread: Re: request for help with COPY syntax
- Next by thread: Re: request for help with COPY syntax
- Indexes: