pgloader is an open-source command-line tool, written and maintained by Dimitri Fontaine, that loads data into PostgreSQL from CSV and fixed-format files or directly from MySQL, SQLite, and Microsoft SQL Server databases using PostgreSQL's COPY streaming protocol. Rather than aborting a migration on the first bad row, pgloader logs rejected rows and their errors to separate reject files and keeps loading the rest of the data set. The project is released under the PostgreSQL License and is maintained by its open-source community on GitHub rather than by a company; pgloader 4, a rewrite targeting the JVM, succeeded the long-running Common Lisp-based v3 series.
Data Modernization
pgloader is an open-source command-line tool, written and maintained by Dimitri Fontaine, that loads data into PostgreSQL from CSV and fixed-format files or directly from MySQL, SQLite, and Microsoft SQL Server databases using PostgreSQL's COPY streaming protocol. Rather than aborting a migration on the first bad row, pgloader logs rejected rows and their errors to separate reject files and keeps loading the rest of the data set. The project is released under the PostgreSQL License and is maintained by its open-source community on GitHub rather than by a company; pgloader 4, a rewrite targeting the JVM, succeeded the long-running Common Lisp-based v3 series.
