Re: Wierd error for COPY command

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: 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:15:45
Message-ID: web-1385697@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message PG Explorer 2002-04-26 17:25:38 Re: Wierd error for COPY command
Previous Message Christoph Haller 2002-04-26 17:05:27 view on system tables upgrade?