From: Guy Fraser <guy@incentre.net>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: CSV import
Date: Fri, 31 Jan 2003 18:32:08 -0700
Message-ID: <3E3B2398.1010101@incentre.net> (raw)
References: <3E3697AF.2030509@aon.at>
<3E370095.3020200@incentre.net>
<3E373369.52C862DE@nsd.ca>
<013601c2c8a0$f6ca2280$32021aac@chad>
<3E3A95F3.842C9691@nsd.ca>
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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: guy@incentre.net
Subject: Re: CSV import
In-Reply-To: <3E3B2398.1010101@incentre.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox