SQLFORMAT

NAME

sqlformat − reformat SQL

SYNOPSIS

sqlformat [ OPTION ] ... [ FILE ] ...

DESCRIPTION

The ‘sqlformat’ command-line tool can be used to reformat SQL file according to specified options or prepare a snippet in in some programming language (only Python and PHP currently supported). Use "-" for FILE to read from stdin.

OPTIONS

−i CHOICE|−−identifiers=FORMAT

Change case of identifiers. FORMAT is one of "upper", "lower", "capitalize".

−k CHOICE|−−keywords=FORMAT

Change case of keywords. FORMAT is one of "upper", "lower", "capitalize".

−l CHOICE|−−language=LANG

Output a snippet in programming language LANG. LANG can be "python", "php".

−o FILE|−−outfile=FILE

Write output to FILE (defaults to stdout).

−r|−−reindent

Reindent statements.

−−indent_width=INDENT_WIDTH

Set indent width to INDENT_WIDTH. Default is 2 spaces.

−−wrap_after=WRAP_AFTER

The column limit for wrapping comma-separated lists. If unspecified, it puts every item in the list on its own line.

−−strip−comments

Remove comments.

−h|−−help

Print a short help message and exit. All subsequent options are ignored.

--verbose

Verbose output.

−−version

Print program’s version number and exit.

AUTHORS

This man page was written by Andriy Senkovych <jolly_roger AT itblog DOT org DOT ua>