When you need to import data through CSV files there’s more than one gem that can help you do the job. But what if you need to import large CSV files (~100MB / ~1M rows)?

PostgreSQL has a really powerful yet very simple command called COPY which copies data between a file and a database table.