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 ofpgloader
, 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'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:
- Identify the data files and where they are located. Make sure that
pgloader
is installed at the location of the files. - Identify the table into which you are loading, ensure that you have the permissions to load, and check the available...