NAME¶

pgpp - PostgreSQL language prettifier

DESCRIPTION¶

usage: pgpp [-h] [-v] [-p] [-t] [-n] [-m COMPACT_LISTS_MARGIN]

: [-s SPLIT_STRING_LITERALS] [-f] [-F] [-c] [-e] [-C] [-S STATEMENT] [infile] [outfile]

PostgreSQL language prettifier

infile: a file containing the SQL statement to be prettyprinted, by default stdin, when not specified with --statement option
outfile: where the result will be written, by default stdout

-h, --help: show this help message and exit
-v, --version: show program's version number and exit
-p, --plpgsql: use the plpgsql parser (implies --parse-tree)
-t, --parse-tree: show the resulting parse tree instead
-n, --normalize: show the normalized statement, without prettification (some options below may have no effect)
-m COMPACT_LISTS_MARGIN, --compact-lists-margin COMPACT_LISTS_MARGIN: use compact form for lists not exceeding the given margin
-s SPLIT_STRING_LITERALS, --split-string-literals SPLIT_STRING_LITERALS: split string literals longer than given value
-f, --special-functions: activate special functions handling
-F, --remove-pg_catalog-from-functions: omit explicit "pg_catalog" schema from function names, when possible
-c, --comma-at-eoln: use alternative style to print lists, putting the comma right after each item
-e, --semicolon-after-last-statement: end the last statement with a semicolon
-C, --preserve-comments: preserve comments in the statement
-S STATEMENT, --statement STATEMENT: the SQL statement

December 2024

pgpp with PostgreSQL 17.0 parser