Re: [SQL] Importing data from csv

[Aaron Bono]

On 8/24/06, Sumeet <[EMAIL PROTECTED]> 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
==================================================================