Re: CSV import - Mailing list pgsql-sql

From Guy Fraser
Subject Re: CSV import
Date
Msg-id 3E3B2398.1010101@incentre.net
Whole thread Raw
In response to CSV import  (Oliver Vecernik <vecernik@aon.at>)
List 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 by date:

Previous
From: Luis Magaña
Date:
Subject: For each record in SELECT
Next
From: "Andrew J. Kopciuch"
Date:
Subject: Re: For each record in SELECT