Re: Wierd error for COPY command

From: "PG Explorer" <pgmail(at)pgexplorer(dot)com>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Wierd error for COPY command
Date: 2002-04-26 17:25:38
Message-ID: 001601c1ed47$632ae120$c80ba8c0@sabex.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)postgresql(dot)org)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-04-26 19:38:44 Wierd query behaviour
Previous Message Josh Berkus 2002-04-26 17:15:45 Re: Wierd error for COPY command