Man page - pgpp(1)

Packages contains this manual

Manual

PGPP

NAME
DESCRIPTION
positional arguments:
options:

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