| 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: | Whole Thread | Raw Message | 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
> 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)
| 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 |