pgloader

extract, transform and load data into PostgreSQL

Description

pgloader imports data from different kind of sources and COPY it into PostgreSQL.

The command language is described in the manual page and allows one to describe where to find the data source, its format, and to describe data processing and transformation.

Supported source formats include CSV, fixed width flat files, dBase3 files (DBF), and SQLite and MySQL databases. In most of those formats, pgloader is able to auto-discover the schema and create the tables and the indexes in PostgreSQL. In the MySQL case it's possible to edit CASTing rules from the pgloader command directly.

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Upload a screenshot

Hint: upload an image here from your clipboard with Ctrl-V


Homepage

https://github.com/dimitri/pgloader


Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…

Install pgloader