---
name: "pgloader"
section: "1"
platform: "linux"
package: "pgloader"
version: "3.6.10-4"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/pgloader"
---

# pgloader(1)

extract, transform and load data into PostgreSQL

## NAME

pgloader - extract, transform and load data into PostgreSQL

## DESCRIPTION

pgloader \[ option ... \] command-file ... pgloader \[ option ... \] SOURCE TARGET

- **--help** **-h**

  boolean  Show usage and exit.

- **--version** **-V**

  boolean  Displays pgloader version and exit.

- **--quiet** **-q**

  boolean  Be quiet

- **--verbose** **-v**

  boolean  Be verbose

- **--debug** **-d**

  boolean  Display debug level information.

- **--client-min-messages**

  string   Filter logs seen at the console (default: "warning")

- **--log-min-messages**

  string   Filter logs seen in the logfile (default: "notice")

- **--summary** **-S**

  string   Filename where to copy the summary

- **--root-dir** **-D**

  string   Output root directory. (default: #P"/tmp/pgloader/")

- **--upgrade-config** **-U**

  boolean  Output the command(s) corresponding to .conf file for v2.x

- **--list-encodings** **-E**

  boolean  List pgloader known encodings and exit.

- **--logfile** **-L**

  string   Filename where to send the logs.

- **--load-lisp-file** **-l**

  string   Read user code from files

- **--dry-run**

  boolean  Only check database connections, don't load anything.

- **--on-error-stop**

  boolean  Refrain from handling errors properly.

- **--no-ssl-cert-verification**

  boolean  Instruct OpenSSL to bypass verifying certificates.

- **--context** **-C**

  string   Command Context Variables

- **--with**

  string   Load options

- **--set**

  string   PostgreSQL options

- **--field**

  string   Source file fields specification

- **--cast**

  string   Specific cast rules

- **--type**

  string   Force input source type

- **--encoding**

  string   Source expected encoding

- **--before**

  string   SQL script to run before loading the data

- **--after**

  string   SQL script to run after loading the data

- **--self-upgrade**

  string   Path to pgloader newer sources

- **--regress**

  boolean  Drive regression testing