PGPP

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