Re: CSV import

From: Guy Fraser <guy(at)incentre(dot)net>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: CSV import
Date: 2003-02-01 01:32:08
Message-ID: 3E3B2398.1010101@incentre.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew J. Kopciuch 2003-02-01 02:36:17 Re: [SQL] For each record in SELECT
Previous Message Keary Suska 2003-02-01 01:28:34 Re: For each record in SELECT