copy from postgres table to csv rows splitted

Asked Jul 14 '17 at 08:10

Active Jul 14 '17 at 08:46

Viewed 23 times

I'm making a copy from a postgres table to a csv file. My command is:

copy tableA to 'C:/test/tableA.csv' CSV DELIMITER ','  HEADER ENCODING 'UTF-8'

This command worked fine for millions of cases but now I have lines on the csv that are splitting. Probably in postgres records there are extravagant characters but I dont see nothing. Can anybody help me? Thank you

edited Jul 14 '17 at 08:46

Vao Tsun

42,665
8
85
115

asked Jul 14 '17 at 08:10

Gian Piero

\copy tableA to '/test/tableA.csv' with delimiter ',' csv header quote as '"' – kimdasuncion12 Jul 14 '17 at 08:27
thanks but doesnt work – Gian Piero Jul 14 '17 at 08:42
whats the exact error?.. – Vao Tsun Jul 14 '17 at 08:47
one row table is splitted in csv file in 3 different row as if there are 2 "carriage return" – Gian Piero Jul 14 '17 at 08:48

copy from postgres table to csv rows splitted

0 Answers0