pgloader

pgloader is a data migration tool designed to load data into PostgreSQL from various sources. It automates the process of migrating databases, handling schema transformations and data type conversions. pgloader supports high-speed data loading using PostgreSQL's COPY command and provides detailed logs for monitoring the migration process.

Features

Supports migration from MySQL, SQLite, and CSV files
Automated schema and data type conversion
High-speed data loading using PostgreSQL's COPY command
Error handling with separate logs for rejected data
Command-line interface for scripting and automation
Open-source under the PostgreSQL license

Project Samples

Project Activity

See All Activity >

License

MIT License

Follow pgloader

pgloader Web Site

Other Useful Business Software

Premier Construction Software

Premier is a global leader in financial construction ERP software.

Rated #1 Construction Accounting Software by Forbes Advisor in 2022 & 2023. Our modern SAAS solution is designed to meet the needs of General Contractors, Developers/Owners, Homebuilders & Specialty Contractors.

Learn More

Rate This Project

User Reviews

Be the first to post a review of pgloader!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

Common Lisp

Related Categories

Common Lisp Database Software

Registered

2025-06-02

Similar Business Software

Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
DbVisualizer

DbVisualizer is a universal database client for developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

See Software
Google Cloud BigQuery

BigQuery is a serverless, multicloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely...

See Software
Google Cloud Platform

Google Cloud is a cloud-based service that allows you to create anything from simple websites to complex applications for businesses of all sizes. New customers get $300 in free credits to run, test, and deploy workloads. All customers can use 25+ products for free, up to monthly usage...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
dbForge Data Compare for PostgreSQL

dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. It helps to custom-tailor the detection of data differences between two PostgreSQL tables, establish smart management of inconsistencies and safe deployment of changes. This PostgreSQL diff tool also...

See Software