Project Summary
Loading data into PostgreSQL
pgloader is a data loading tool for PostgreSQL, using the COPY command.
Its main avantage over just using COPY or \copy and over using a Foreign Data Wrapper is the transaction behaviour, where pgloader will keep a separate file of rejected data and continue trying to copy good data in your database.
The default PostgreSQL behaviour is transactional, which means that any erroneous line in the input data (file or remote database) will stop the bulk load for the whole table.
pgloader also implements data reformating, the main example of that being a transformation from MySQL dates 0000-00-00 and 0000-00-00 00:00:00 to PostgreSQL NULL value (because our calendar never had a year zero).
Badges
In a Nutshell, pgloader...
- ...
- ...
-
...
has a well established, mature codebase
maintained by a small development team
with decreasing Y-O-Y commits -
...
took an estimated 12 years of effort (COCOMO model)
starting with its first commit in January, 2013
ending with its most recent commit 6 months ago
Quick Reference
Project Security
Vulnerabilities per Version ( last 10 releases )
There are no reported vulnerabilities
Project Vulnerability Report
Security Confidence Index
Vulnerability Exposure Index
Did You Know...
-
...
there are over 3,000 projects on the Open Hub with security vulnerabilities reported against them
-
...
you can subscribe to e-mail newsletters to receive update from the Open Hub blog
-
...
in 2016, 47% of companies did not have formal process in place to track OS code
-
...
anyone with an Open Hub account can update a project's tags
30 Day SummaryOct 29 2025 — Nov 28 2025
|
12 Month SummaryNov 28 2024 — Nov 28 2025
|
