Re: CSV import

Поиск
Список
Период
Сортировка
От Guy Fraser
Тема Re: CSV import
Дата
Msg-id 3E3B2398.1010101@incentre.net
обсуждение исходный текст
Ответ на CSV import  (Oliver Vecernik <vecernik@aon.at>)
Список pgsql-sql
FYI

In text files on a Mac. the EOL character is a <CR> only.

What a messy thing this whole EOL cruft is.

To convert between these text formats on linux is easy if you have dos2unix.

The dos2unix on linux can perform many format conversions to and from unix,dos 
and mac formats.

On BSD you need dos2unix to convert from dos to unix and unix2dos to convert 
from unix to dos. You probably need to get the GNU version of dos2unix or 
mac2unix to convert to or from mac formatted text.


Guy

Jean-Luc Lachance wrote:
> In DOS and Windows, text lines end with <CR><LF>.
> In Unix, text lines end with <LF> only.
> 
>                 hex   dec    oct
> <CR>=CTRL-M or 0x0D or 13 or 015
> <LF>=CTRL-J or 0x0A or 10 or 012
> 
> 
> 
> Chad Thompson wrote:
> 
>>>Unix EOL is LF not CR.
>>>
>>>
>>
>>Is this the only difference between a dos and unix text file?
>>
>>Thanks
>>Chad
---%<...snip...



В списке pgsql-sql по дате отправления:

Предыдущее
От: Luis Magaña
Дата:
Сообщение: For each record in SELECT
Следующее
От: "Andrew J. Kopciuch"
Дата:
Сообщение: Re: For each record in SELECT