SQL indentation general - sqlparser/sql-pretty-printer GitHub Wiki

  • General indentation size

    Option: fmt124_indent_generic = n, type: TFmtInt.

    General indentation size is used to indent SQL code if there is no specific indent option provided for this SQL segment. Select list in following SQL was indented by 2 spaces.

    SELECT 
  lastname, 
  firstname, 
  jobtitle, 
  department  
FROM   humanresources.vemployeedepartment;

  • Use tab to indent

    Option: fmt125_indent_use_tab = false, type: TFmtBoolean.

    Option: fmt126_indent_tab_size = n, type: TFmtInt.

    Use tab character instead of space to indent SQL segment. Tab size means how many spaces of one tab.

  • Indentation of SQL block