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
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: Top 10 - Celebridades - Música - Esportes
