Loading DBF data¶
This command instructs pgloader to load data from a DBF file. Here’s an example:
LOAD DBF FROM http://www.insee.fr/fr/methodes/nomenclatures/cog/telechargement/2013/dbf/reg2013.dbf INTO postgresql://user@localhost/dbname WITH truncate, create table;
The dbf format command accepts the following clauses and options.
DBF Source Specification: FROM¶
Filename where to load the data from. This support local files, HTTP URLs and zip files containing a single dbf file of the same name. Fetch such a zip file from an HTTP address is of course supported.
DBF Loading Options: WITH¶
When loading from a DBF file, the following options are supported:
When this option is listed, pgloader issues a TRUNCATE command against the PostgreSQL target table before reading the data file.
When this option is listed, pgloader issues an ALTER TABLE … DISABLE TRIGGER ALL command against the PostgreSQL target table before copying the data, then the command ALTER TABLE … ENABLE TRIGGER ALL once the COPY is done.
This option allows loading data into a pre-existing table ignoring the foreign key constraints and user defined triggers and may result in invalid foreign key constraints once the data is loaded. Use with care.
When this option is listed, pgloader creates the table using the meta data found in the DBF file, which must contain a list of fields with their data type. A standard data type conversion from DBF to PostgreSQL is done.
This options expects as its value the possibly qualified name of the table to create.