.\" DO NOT MODIFY THIS FILE! It was generated by help2man 1.49.3. .TH PGLOADER "1" "March 2024" "pgloader 3.6.10" "User Commands" .SH NAME pgloader \- extract, transform and load data into PostgreSQL .SH DESCRIPTION pgloader [ option ... ] command\-file ... pgloader [ option ... ] SOURCE TARGET .TP \fB\-\-help\fR \fB\-h\fR boolean Show usage and exit. .TP \fB\-\-version\fR \fB\-V\fR boolean Displays pgloader version and exit. .TP \fB\-\-quiet\fR \fB\-q\fR boolean Be quiet .TP \fB\-\-verbose\fR \fB\-v\fR boolean Be verbose .TP \fB\-\-debug\fR \fB\-d\fR boolean Display debug level information. .TP \fB\-\-client\-min\-messages\fR string Filter logs seen at the console (default: "warning") .TP \fB\-\-log\-min\-messages\fR string Filter logs seen in the logfile (default: "notice") .TP \fB\-\-summary\fR \fB\-S\fR string Filename where to copy the summary .TP \fB\-\-root\-dir\fR \fB\-D\fR string Output root directory. (default: #P"/tmp/pgloader/") .TP \fB\-\-upgrade\-config\fR \fB\-U\fR boolean Output the command(s) corresponding to .conf file for v2.x .TP \fB\-\-list\-encodings\fR \fB\-E\fR boolean List pgloader known encodings and exit. .TP \fB\-\-logfile\fR \fB\-L\fR string Filename where to send the logs. .TP \fB\-\-load\-lisp\-file\fR \fB\-l\fR string Read user code from files .TP \fB\-\-dry\-run\fR boolean Only check database connections, don't load anything. .TP \fB\-\-on\-error\-stop\fR boolean Refrain from handling errors properly. .TP \fB\-\-no\-ssl\-cert\-verification\fR boolean Instruct OpenSSL to bypass verifying certificates. .TP \fB\-\-context\fR \fB\-C\fR string Command Context Variables .TP \fB\-\-with\fR string Load options .TP \fB\-\-set\fR string PostgreSQL options .TP \fB\-\-field\fR string Source file fields specification .TP \fB\-\-cast\fR string Specific cast rules .TP \fB\-\-type\fR string Force input source type .TP \fB\-\-encoding\fR string Source expected encoding .TP \fB\-\-before\fR string SQL script to run before loading the data .TP \fB\-\-after\fR string SQL script to run after loading the data .TP \fB\-\-self\-upgrade\fR string Path to pgloader newer sources .TP \fB\-\-regress\fR boolean Drive regression testing