pgpp - PostgreSQL language prettifier
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
- 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 (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