pgloader Import CSV data and Large Object to PostgreSQL
Download

pgloader Ranking & Summary

pgloader Tags

database load PostgreSQL PostgreSQL loader PostgreSQL importer data loader

pgloader Description

Import CSV data and Large Object to PostgreSQL pgloader (PostgreSQL Loader) is a fast and free data loader for PostgreSQL, with the ability to generate files of rejected rows.pgloader imports data from a flat file and insert it into a database table. It uses a flat file per database table, and you can configure as many Sections as you want, each one associating a table name and a data file.Data are parsed and rewritten, then given to PostgreSQL COPY command. Parsing is necessary for dealing with end of lines and eventual trailing separator characters, and for column reordering: your flat data file may not have the same column order as the database table has.pgloader is also able to load some large objects data into PostgreSQL, as of now only Informix UNLOAD data files are supported. This command gives large objects data location information into the main data file. pgloader parse it add the text or bytea content properly escaped to the COPY data. Requirements: · Python · Psycopg What's New in This Release: · FIX: Add database opening into critical path (BoundedSemaphore) · FIX: close database connection as soon as possible · Add support for fixed format

pgloader Related Software