COPY ERROR

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: COPY ERROR
Date: 2010-03-29 20:20:36
Message-ID: 32476.95498.qm@web52507.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
When I try to import big file base.txt( 700MB),I get this:

xxxxx=# create table arquivo_serasa_marco( varchar(3000));
xxxxx=# COPY arquivo_serasa_marco from '/usr/local/pgsql/data/base.txt';
ERROR: literal newline found in data
HINT: Use "\n" to represent newline.
CONTEXT: COPY arquivo_serasa_marco, line 2: ""

How can find solution for this?

Regards

Paul

____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Keller 2010-03-29 21:10:53 Re: hstore equality-index performance question
Previous Message Arthur Turrini 2010-03-29 18:46:24 Re: Side effect of synchronous_commit = off