Re: Data loading from a flat file...

From: Bricklen Anderson <banderson(at)presinet(dot)com>
To: Pandurangan R S <pandurangan(dot)r(dot)s(at)gmail(dot)com>
Cc: Angshu Kar <angshu96(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Data loading from a flat file...
Date: 2006-01-06 15:05:50
Message-ID: 43BE874E.7080600@presinet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pandurangan R S wrote:
> To get rid of ^M characters you could use
>
> cat file | tr -d ^M
>
> you need to type ^V before you type ^M in the preceeding command. But
> ^V will not be displayed on the screen.

Or you can use dos2unix/unix2dos, if installed. I believe they are in
the sysutils package.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2006-01-06 15:15:57 Re: "Could not open relation with OID x" while deleting a row
Previous Message Florent Garcin 2006-01-06 11:33:08 constraint on type object in oracle