pgloader1

Extract, transform and load data into postgresql

Overview

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

Releases

9 releases since Debian 5.0 (Lenny); the text changed 8 times.

--after since Debian 10 (Buster); --before since Debian 10 (Buster); --cast since Debian 10 (Buster); --client-min-messages since Debian 10 (Buster); --context since Debian 10 (Buster); --debug since Debian 10 (Buster); --dry-run since Debian 10 (Buster); --encoding since Debian 10 (Buster); --field since Debian 10 (Buster); --help since Debian 8 (Jessie); --list-encodings since Debian 8 (Jessie); --load-lisp-file since Debian 10 (Buster); --log-min-messages since Debian 10 (Buster); --logfile since Debian 10 (Buster); --no-ssl-cert-verification since Debian 10 (Buster); --on-error-stop since Debian 10 (Buster); --quiet since Debian 10 (Buster); --regress since Debian 10 (Buster); --root-dir since Debian 10 (Buster); --self-upgrade since Debian 10 (Buster); --set since Debian 10 (Buster); --summary since Debian 10 (Buster); --type since Debian 10 (Buster); --upgrade-config since Debian 8 (Jessie); --verbose since Debian 10 (Buster); --with since Debian 10 (Buster); -C since Debian 10 (Buster); -D since Debian 10 (Buster); -L since Debian 10 (Buster); -S since Debian 10 (Buster); -U since Debian 8 (Jessie); -d since Debian 10 (Buster); -h since Debian 8 (Jessie); -l since Debian 10 (Buster); -q since Debian 10 (Buster); -v since Debian 10 (Buster).

--boundaries until Debian 7 (Wheezy); --config until Debian 7 (Wheezy); --count until Debian 7 (Wheezy); --disable-triggers until Debian 7 (Wheezy); --field-sep until Debian 7 (Wheezy); --from until Debian 7 (Wheezy); --from-id until Debian 7 (Wheezy); --load-from-stdin until Debian 7 (Wheezy); --load-to-table until Debian 7 (Wheezy); --loglevel until Debian 7 (Wheezy); --max-parallel-sections until Debian 7 (Wheezy); --pedantic until Debian 7 (Wheezy); --pg-options until Debian 7 (Wheezy); --psycopg-version until Debian 7 (Wheezy); --psycopg1 until Debian 7 (Wheezy); --psycopg2 until Debian 7 (Wheezy); --reformat_path until Debian 7 (Wheezy); --reject-data until Debian 7 (Wheezy); --reject-log until Debian 7 (Wheezy); --section-threads until Debian 7 (Wheezy); --truncate until Debian 7 (Wheezy); --vacuum until Debian 7 (Wheezy); -1 until Debian 7 (Wheezy); -2 until Debian 7 (Wheezy); -F until Debian 7 (Wheezy); -I until Debian 7 (Wheezy); -R until Debian 7 (Wheezy); -T until Debian 7 (Wheezy); -c until Debian 7 (Wheezy); -f until Debian 7 (Wheezy); -j until Debian 7 (Wheezy); -m until Debian 7 (Wheezy); -n until Debian 7 (Wheezy); -o until Debian 7 (Wheezy); -p until Debian 7 (Wheezy); -r until Debian 7 (Wheezy); -s until Debian 7 (Wheezy); -t until Debian 7 (Wheezy).