Received: from homer.websystems.co.za (unknown [196.25.70.70]) by postgresql.org (Postfix) with ESMTP id D343C474E4E for ; Fri, 26 Apr 2002 13:26:10 -0400 (EDT) Received: from hano (bnb53-01-p156.nt.saix.net [155.239.180.156]) by homer.websystems.co.za (8.11.0/8.11.0) with SMTP id g3QHddE16199; Fri, 26 Apr 2002 19:39:39 +0200 Message-ID: <001601c1ed47$632ae120$c80ba8c0@sabex.com> From: "PG Explorer" To: "Josh Berkus" , "Tom Lane" Cc: References: Subject: Re: Wierd error for COPY command Date: Fri, 26 Apr 2002 19:25:38 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 x-mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200204/331 X-Sequence-Number: 7595 need dos2unix do you? here is a script #!/bin/sh tr -d '\015' < $0 > $1 chmod +x dos2unix usage : dos2unix dosfile unixfile http://www.pgexplorer.com > Tom, > > > Yes, you're right. Apparently I have /r/n newlines, plus a ZL string > > in the last field indicating Null. I know that there's a command > > line > > utility to convert DOS newlines into UNIX newlines; could anyone give > > me a name? > > Answered my own question. The utility "dos2unix" (which is a script > file on top of "recode") is included in most Linux distributions. It > works as follows: > either: > dos2unix filename > or: > dos2unix filename newfilename > ... depending on your distro. > > Thanks! > > -Josh Berkus > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)