Import CSV file to a Database, quickly

Challenge: you have a csv file and you need to import it into a new table in a database. You have 5 mins to get it done. What tools do you use?

@secretgeek

Below are many different solutions to this common problem, for a variety of databases and operating systems.

(No examples available, so use solutions for "Any database with any OS")

Two techniques: Copy command in sql itself, and \copy command in psql (interactive commandline).

β™₯ Love CSV? Hate CSV? Try NimbleText for your CSV transforming needs.