PGPP(1)

✨ PGPP 💅

okay bestie, listen up — this is the manual page for pgpp, the PostgreSQL language prettifier. yeah. it makes your crusty SQL look ✨beautiful✨. i'm not kidding, this thing is genuinely iconic and i'm gonna walk you through every single flag like a true main character. 🎀

---

🌸 NAME 🌸

pgpp — the PostgreSQL language prettifier. that's it, that's the whole vibe. it takes SQL that looks like it got dragged through a hedge backwards and hands you back something you'd actually screenshot. 💖

---

🦋 SYNOPSIS 🦋

usage: pgpp [-h] [-v] [-p] [-t] [-n] [-m COMPACT_LISTS_MARGIN]
       [-s SPLIT_STRING_LITERALS] [-f] [-F] [-c] [-e] [-C] [-S STATEMENT] [infile] [outfile]

---

👑 DESCRIPTION 👑

PostgreSQL language prettifier ✨

that's the tagline, that's the energy. now let's get into the actual parts, because there's a lot of levers to pull here and every single one of them is getting its moment. no skipping, no summarising, we are doing ALL of them. periodt. 💅

📥 positional arguments:

• infile — a file containing the SQL statement you want prettyprinted. if you don't hand one over, it reads from stdin by default. (and heads up, if you used the --statement option, this input source doesn't apply — see the note on it below 👀)
• outfile — where the gorgeous result gets written. left alone, it goes to stdout like a good little default.

🎛️ options:

• -h, --help — shows this help message and then dips out. classic.
• -v, --version — shows the program's version number and exits. quick flex.
• -p, --plpgsql — use the plpgsql parser. lowkey important: this one implies --parse-tree, so you don't have to ask twice. 🫶
• -t, --parse-tree — instead of prettifying, show the resulting parse tree. it's giving "peek behind the curtain". 🌈
• -n, --normalize — show the normalized statement, with no prettification at all. ngl, some of the options below may straight up have no effect when you use this one. not being shady, that's just how it is. 😭
• -m, --compact-lists-margin COMPACT_LISTS_MARGIN — use the compact form for lists that don't exceed the margin you give it. small lists get the cosy treatment. 🍓
• -s, --split-string-literals SPLIT_STRING_LITERALS — split string literals that are longer than the value you give. long strings found deceased. 💀
• -f, --special-functions — activates special functions handling. turn it on and let it cook. 🔥
• -F, --remove-pg_catalog-from-functions — omit the explicit "pg_catalog" schema from function names, when possible. tidier, cleaner, slay. ✨
• -c, --comma-at-eoln — an alternative style for printing lists: it puts the comma right after each item. yes, that argument. the eternal one. pick your side, bestie. 💅
• -e, --semicolon-after-last-statement — ends the last statement with a semicolon. closure. we love that for you. 🎀
• -C, --preserve-comments — preserves the comments in the statement. your little notes stay exactly where you left them, protected, thriving. 💜
• -S, --statement STATEMENT — the SQL statement itself, passed right here on the command line.

heads up bestie: when you use -S/--statement, that's where the SQL comes from — the infile slot (which is stdin by default) isn't the source in that case. iykyk. 🙈

---

🌈 that's a wrap 🌈

this page came to you courtesy of pgpp running with the PostgreSQL 18.4 parser, dated July 2026 — and it's filed under User Commands, section 1 of the manual, which is the iconic-est section imo. 🧚 go forth and prettify, you absolute legend, you ate. 👑⭐💖