Re: Wierd error for COPY command

Поиск
Список
Период
Сортировка
От PG Explorer
Тема Re: Wierd error for COPY command
Дата
Msg-id 001601c1ed47$632ae120$c80ba8c0@sabex.com
обсуждение исходный текст
Ответ на Re: Wierd error for COPY command  ("Josh Berkus" <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: Wierd error for COPY command
Следующее
От: Robert Wynter
Дата:
Сообщение: union query format