Now attached.
----- Mensagem encaminhada ----
De: paulo matadr <saddon...@yahoo.com.br>
Para: Albe Laurenz <laurenz.a...@wien.gv.at>
Cc: GENERAL <pgsql-general@postgresql.org>
Enviadas: Quarta-feira, 31 de Março de 2010 11:03:01
Assunto: Res: [GENERAL] COPY ERROR
Txt file,
I belive that file not put \n on the end of line,this is possible?
follow example in attach.
________________________________
De: Albe Laurenz <laurenz.a...@wien.gv.at>
Para: paulo matadr *EXTERN* <saddon...@yahoo.com.br>; GENERAL
<pgsql-general@postgresql.org>
Enviadas: Terça-feira, 30 de Março de 2010 4:03:51
Assunto: Re: [GENERAL] COPY ERROR
paulo matadr wrote:
> 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?
The file does not seem to be in valid COPY format.
What is the format of the file?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
________________________________
Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 -
Celebridades - Música - Esportes
____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com2 2017020204DJALMA ANIZIO TAVARES 2536422398468
2340069 04061993SSP PE281019640001CELINA BARBOSA TAVARES
101000061734AVENIDA PRESIDENTE TANCREDO
NEVES
4 00
2 2007138857VALDSON FERREIRA DA SILVA 2578115450472
00000000 160319700001
101000056094TRAVESSA BEJAMIM 10
4 00
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
