ref/dbf

ref/dbf

Loading DBF data

This command instructs pgloader to load data from a [DBF]{.title-ref} file. A default set of casting rules are provided and might be overloaded and appended to by the command.

Using advanced options and a load command file

Here\’s an example with a remote HTTP source and some user defined casting rules. The command then would be:

$ pgloader dbf.load

And the contents of the dbf.load file could be inspired from the following:

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
    CAST column reg2013.region to integer,
         column reg2013.tncc to smallint;

Common Clauses

Please refer to common_clauses{.interpreted-text role=“ref”} for documentation about common clauses.

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]{.title-ref} file, the following options are supported:

  • truncate

    When this option is listed, pgloader issues a [TRUNCATE]{.title-ref} command against the PostgreSQL target table before reading the data file.

  • disable triggers

    When this option is listed, pgloader issues an [ALTER TABLE ... DISABLE TRIGGER ALL]{.title-ref} command against the PostgreSQL target table before copying the data, then the command [ALTER TABLE ... ENABLE TRIGGER ALL]{.title-ref} once the [COPY]{.title-ref} 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.

  • create table

    When this option is listed, pgloader creates the table using the meta data found in the [DBF]{.title-ref} file, which must contain a list of fields with their data type. A standard data type conversion from DBF to PostgreSQL is done.

  • table name

    This options expects as its value the possibly qualified name of the table to create.

Default DB3 Casting Rules

When migrating from DB3 the following Casting Rules are provided:

type C to text using db3-trim-string
type M to text using db3-trim-string
type N to numeric using db3-numeric-to-pgsql-integer
type I to numeric using db3-numeric-to-pgsql-numeric
type L to boolean using logical-to-boolean
type D to date using db3-date-to-pgsql-date