paulo matadr wrote:
>>> When I try to import big file base.txt( 700MB),I get this:
>>>
>>> x=# create table arquivo_serasa_marco( varchar(3000));
>>> x=# COPY arquivo_serasa_marco from
>>>
>>> ERROR: literal newline found in data
>>> HINT: Use "\n" to represent newline.
>>> CONTEXT: CO
Now attached.
- Mensagem encaminhada
De: paulo matadr
Para: Albe Laurenz
Cc: GENERAL
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
Txt file,
I belive that file not put \n on the end of line,this is possible?
follow example in attach.
De: Albe Laurenz
Para: paulo matadr *EXTERN* ; GENERAL
Enviadas: Terça-feira, 30 de Março de 2010 4:03:51
Assunto: Re: [GENERAL] COPY ERROR
paulo matad
