Enc: Res: COPY ERROR

[paulo matadr <saddoness@xxxxxxxxxxxx>]

Now attached.

----- Mensagem encaminhada ----
De: paulo matadr <saddoness@xxxxxxxxxxxx>
Para: Albe Laurenz <laurenz.albe@xxxxxxxxxx>
Cc: GENERAL <pgsql-general@xxxxxxxxxxxxxx>
Enviadas: Quarta-feira, 31 de Março de 2010 11:03:01
Assunto: Res: 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.albe@xxxxxxxxxx>
Para: paulo matadr *EXTERN* <saddoness@xxxxxxxxxxxx>; GENERAL <pgsql-general@xxxxxxxxxxxxxx>
Enviadas: Terça-feira, 30 de Março de 2010 4:03:51
Assunto: Re: 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@xxxxxxxxxxxxxx)
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: Top 10 - Celebridades - Música - Esportes
2 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general