Re: Error on import - Mailing list pgsql-general

From John
Subject Re: Error on import
Date
Msg-id 000001c27bd8$03f53870$0400a8c0@eclipse
Whole thread Raw
In response to Re: Error on import  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Error on import  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Thanks Tom.. I had a buddy who works with perl give me a little help
since I couldn't get vim to see the \r.. the following one liner got me
where I needed to be. Thanks again.

cat origfile|perl -e 'while (<>){$_ =~ s/\r//g;print $_;}' > prepfile

-----Original Message-----
I think you've got DOS-style newlines (\r\n) in your data file.
Get rid of the carriage return characters (\r) and you'll be set.

            regards, tom lane


pgsql-general by date:

Previous
From: Mike Beachy
Date:
Subject: Re: referential integrity violation
Next
From: Medi Montaseri
Date:
Subject: Re: Error on import