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
==================================================================
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 |