Reference

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

History

--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).