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

   positional arguments:
       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

   options:
       -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
              use compact form for lists not exceeding the given margin

       -s, --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
              the SQL statement

pgpp with PostgreSQL 17.0 parser                   March 2025                                            PGPP(1)