Loading data into your database is one of the most important tasks. You need to do this accurately and quickly. Here's how.
You'll need a copy of pgloader, which is commonly available in all main software distribution.
At the time of writing, the current stable version is 3.4.1. The 3.x series is a major rewrite, with many additional features, and the 2.x series is now considered obsolete.
PostgreSQL includes a command named COPY that provides the basic data load/unload mechanism. The COPY command doesn...