COPY Command does not load data from CSV
Posted: Tue Dec 22, 2015 6:30 pm
I have the below command and on execution, the takes a while (approx 3 to 6 mins) and then says 0 Rows Loaded with out any error. I am executing this command on the bash directly. Not sure if any timeout is occuring, but it is expected to load few thousands of rows.
pvsql -e -c "COPY dml_infrastructure__node FROM '/new_fs/upload/node.csv' WITH DELIMITER ',' DIRECT"
COPY dml_infrastructure__node FROM '/new_fs/upload/node.csv' WITH DELIMITER ',' DIRECT
Rows Loaded
-------------
0
(1 row)
Appreciate any help on this.
pvsql -e -c "COPY dml_infrastructure__node FROM '/new_fs/upload/node.csv' WITH DELIMITER ',' DIRECT"
COPY dml_infrastructure__node FROM '/new_fs/upload/node.csv' WITH DELIMITER ',' DIRECT
Rows Loaded
-------------
0
(1 row)
Appreciate any help on this.