Skip site navigation (1) Skip section navigation (2)

Re: copy error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Keith Worthington <keithw(at)narrowpathinc(dot)com>,PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: copy error
Date: 2004-10-15 14:55:48
Message-ID: 9188.1097852148@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> I'd guess that there's a carriage return at the end of line 1.

Looks like that to me too.

> You might need to run your data through a filter before importing
> it into PostgreSQL.  Some systems have a dos2unix program; you could
> also use tr, sed, perl, awk, etc. to strip trailing carriage returns.

Alternatively, update to PG 7.4 or later.  Since 7.4 COPY will attempt
to Do The Right Thing with files containing Windows-style newlines.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Keith WorthingtonDate: 2004-10-15 15:07:50
Subject: Re: copy error
Previous:From: Tom LaneDate: 2004-10-15 14:29:26
Subject: Re: Two table joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group