Welcome to pgloader’s documentation!

Table Of Contents:

• Introduction
  • Continuous Migration
  • Commands
  • Command Line
• PgLoader Tutorial
  • PgLoader Quick Start
  • Loading CSV Data with pgloader
  • Loading Fixed Width Data File with pgloader
  • Loading MaxMind Geolite Data with pgloader
  • Loading dBase files with pgloader
  • Loading SQLite files with pgloader
  • Migrating from MySQL to PostgreSQL
• PgLoader Reference Manual
  • Arguments
  • Options
  • Batches And Retry Behaviour
  • A Note About Performance
  • A Note About Parallelism
  • Source Formats
  • Pgloader Commands Syntax
  • Templating with Mustache
  • Common Clauses
• Loading CSV data
  • CSV Source Specification: FROM
  • Fields Specifications
  • CSV Loading Options: WITH
• Loading Fixed Cols File Formats
  • Fixed File Format Source Specification: FROM
  • Fields Specifications
  • Fixed File Format Loading Options: WITH
• Loading COPY Formatted Files
  • COPY Formatted Files Source Specification: FROM
  • COPY Formatted File Options: WITH
• Loading DBF data
  • DBF Source Specification: FROM
  • DBF Loading Options: WITH
• Loading IXF Data
  • IXF Source Specification: FROM
  • IXF Loading Options: WITH
• Loading From an Archive
  • Archive Source Specification: FROM
  • Archive Sub Commands
  • Archive Final SQL Commands
• Migrating a MySQL Database to PostgreSQL
  • MySQL Database Source Specification: FROM
  • MySQL Database Migration Options: WITH
  • MySQL Database Casting Rules
  • MySQL Views Support
  • MySQL Partial Migration
  • MySQL Encoding Support
  • MySQL Schema Transformations
  • MySQL Migration: limitations
  • Default MySQL Casting Rules
• Migrating a SQLite database to PostgreSQL
  • SQLite Database Source Specification: FROM
  • SQLite Database Migration Options: WITH
  • SQLite Database Casting Rules
  • SQlite Database Partial Migrations
  • Default SQLite Casting Rules
• Migrating a MS SQL Database to PostgreSQL
  • MS SQL Database Source Specification: FROM
  • MS SQL Database Migration Options: WITH
  • MS SQL Database Casting Rules
  • MS SQL Partial Migration
  • MS SQL Schema Transformations
  • MS SQL Driver setup and encoding
  • Default MS SQL Casting Rules
• Transformation Functions
• Reporting Bugs
  • Test Cases to Reproduce Bugs

Indices and tables

• Index
• Module Index
• Search Page