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 that is available at the following website:
PostgreSQL includes a command named
COPY that provides the basic data load/unload mechanism.
COPY doesn't do enough when loading data, so let's skip the basic command and go straight to pgloader.
To load data we need to understand our requirements, so let's break this down into a step-by-step process, as follows: