PGLOADER(1)

💖 pgloader — the manual, but make it cute

okay bestie, welcome to PGLOADER(1), filed under User Commands. yes this is the actual manual page, no I did not skip the boring parts, we are doing all of it together. grab a lil drink 🍓

---

🌸 NAME 🌸

pgloader — extract, transform and load data into PostgreSQL. it's giving pipeline royalty 👑

---

✨ DESCRIPTION ✨

so like, here's the vibe. you run it one of two ways:

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

either you hand it some command-files, or you give it a SOURCE and a TARGET and let it cook. that's the whole energy. 🫶

---

🎀 the flags, bestie (every single one)

every option below is listed with its type (boolean or string), fr fr, no skips:

• --help, -h — boolean. shows usage and dips. iconic.
• --version, -V — boolean. displays the pgloader version and exits. one job, does it 💅
• --quiet, -q — boolean. be quiet 🤫
• --verbose, -v — boolean. be verbose 🗣️
• --debug, -d — boolean. display debug level information. the receipts, all of them.
• --client-min-messages — string. filter the logs you see at the console (default: "warning").
• --log-min-messages — string. filter the logs that go 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. glow-up service ✨
• --list-encodings, -E — boolean. list pgloader's 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. a little vibe check, no commitment 🙈
• --on-error-stop — boolean. refrain from handling errors properly 🫣 yes that's literally what it says, bestie.
• --no-ssl-cert-verification — boolean. instruct OpenSSL to bypass verifying certificates.

⚠️ okay serious face for one sec: that last one tells OpenSSL to skip verifying certificates. that's a real security thing, not a cute little toggle. be careful with it 💀

• --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 🧪

---

and that's the whole page, start to finish, nothing left out. main character tool behavior honestly 👑

this was pgloader 3.6.10, October 2024, and the manual page is PGLOADER(1). mwah, go load some data bestie 💖🌈🎀