20.11 PostgrSQL CSV Import


We can populate a table from a csv file.

kayon=# COPY iris FROM '/home/kayon/iris.csv' WITH (FORMAT csv, HEADER true);
COPY 150

If only specific columns are available in the csv file:

kayon=# COPY iris (sepal_length, species) FROM '/home/kayon/iris.csv' WITH (FORMAT csv, HEADER true);
COPY 150

Your donation will support ongoing availability and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2022 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0