pgloader is a client side data loader for
PostgreSQL. It knows how to find erroneous
rows in your input so that the good ones are loaded in the database and the
bad ones accumulated in a reject file for later processing.
CSV file format, fixed sized file format and text
file format with some advanced parsing options so as to be able to read
pgloader implements many interesting features such as column reformating
in python, user defined constant columns, column remapping between file and
database table, and some more: have a look at the tutorial.
See pgloader tutorial for a complete tutorial explaining in details how to setup and use pgloader.
pgloader is sponsored by 2ndQuadrant, we offer commercial support and training if you need professional help.