Re: Wierd error for COPY command - Mailing list pgsql-sql

From PG Explorer
Subject Re: Wierd error for COPY command
Date
Msg-id 001601c1ed47$632ae120$c80ba8c0@sabex.com
Whole thread Raw
In response to Re: Wierd error for COPY command  ("Josh Berkus" <josh@agliodbs.com>)
List 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@postgresql.org)



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Wierd error for COPY command
Next
From: Robert Wynter
Date:
Subject: union query format