Character string containing one or more SQL statements to be formatted.
keyword_case
Character string specifying how keywords are formatted. Options: "upper", "lower"", and "capitalize". Default: NULL
identifier_case
Character string specifying how identifiers are formatted. Options: "upper", "lower"", and "capitalize". Default: NULL
strip_comments
Boolean; if TRUE comments are removed from the SQL statements. Default: TRUE
reindent
Boolean; if TRUE the indentations of the statements are changed. Default: FALSE
indent_width
Positive integer specifying the width of the indentation. Default: 2
indent_tabs
Boolean; if TRUE tabs instead of spaces are used for indentation. Default: FALSE
indent_after_first
Boolean; if TRUE second line of statement is indented (e.g. after SELECT). Default: FALSE
indent_columns
Boolean; if TRUE all columns are indented by indent_width instead of keyword length. Default: FALSE
reindent_aligned
Boolean; if TRUE the statements are reindented to aligned format. Default: FALSE
use_space_around_operators
Boolean; if TRUE spaces are placed around mathematical operators. Default: FALSE
wrap_after
Positive integer specifying the column limit (in characters) for wrapping comma-separated lists. If NULL, every item is put on its own line. Default: NULL
comma_first
Boolean; if TRUE a linebreak is inserted before comma. Default: FALSE
truncate_strings
Positive integer; string literals longer than the given value are truncated. Default: NULL
truncate_char
Character string appended if long string literals are truncated. Default: "[...]"
encoding