NAME

       pgpp - PostgreSQL language prettifier

DESCRIPTION

       usage: pgpp [-h] [-v] [-p] [-t] [-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 (and print just the resulting tree)

       -t, --parse-tree
              show just the parse tree of the statement

       -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

pgpp with PostgreSQL 16.1 parser                   April 2024                                            PGPP(1)