How to use \copy command in Postgresql for CSV file?

Viewed 18

I myself will be the one answering this question,

The example format is as follow;

\copy track_raw(title,artist,album,count,rating,len) FROM 'library.csv' WITH DELIMITER ',' CSV;

Most probably you are taking the postgresql for everybody course on coursera. The good news is that you can copy the example format above and it will work. Please note: Upload the file if you are using pythoneverywhere.

0 Answers
Related