Re: Importing data from csv

From: "Aaron Bono" <postgresql(at)aranya(dot)com>
To: Sumeet <asumeet(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Importing data from csv
Date: 2006-08-28 04:14:37
Message-ID: bf05e51c0608272114g44476251vf38678883ed71a16@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 8/24/06, Sumeet <asumeet(at)gmail(dot)com> wrote:
>
> Hi Folks,
>
> sorry if this is a duplicate post, i've been tryin to find a solution of
> importing data into postgres from a csv file. The problem is, I have a
> database which consists of columns which contain newline characters (mac and
> unix). now when i export these files to a csv format, there are some line
> breaks (mixed unix and mac) in the data which breaks the copy procedure.
>

Sounds like you are checking the file in as binary when it should be checked
in as ASCII. You may want to consider changing that in your repository so
this does not continue to be an issue.

==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
http://codeelixir.com
==================================================================

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Dinesh Tiwari 2006-08-28 07:47:23 hi ........i have a query related to MS reporting services
Previous Message Aaron Bono 2006-08-28 04:10:06 Re: Performance Problem with sub-select using array