Skip to content

Version 5.4

Compare
Choose a tag to compare
@darold darold released this 11 Jan 08:14
· 43 commits to master since this release

January 11 2023 - v5.4

This maintenance release fixes issues reported by users since the last five
months with some improvements and new features.

New options and features:

  • Add option --no-space-function, when used pgFormatter removes the
    space character between a function call and the open parenthesis that
    follow. By default pgFormatter adds a space character, for example:
    DROP FUNCTION IF EXISTS app_public.hello (a text);
    When this option is used the resulting query is formatted as follow:
    DROP FUNCTION IF EXISTS app_public.hello(a text);
    Available in CGI mode as a checkbox.
  • Add command line option --extra-keyword to apply keywords formatting to
    a list of additional keywords defined in a file (one keyword per line).
    You can also pass a special value 'redshift' instead of a path to a file
    to use the keywords defined internally in pgFormatter for this database.
    This was historically possible through the -r | --redshift option that
    is now obsolete and will be removed in the future. Thanks to Thom Brown
    for the feature request.

Here is the complete list of changes and acknowledgments:

  • Add option --no-space-function. Thanks to Aaron Merryman for the feature request.
  • Fix particular case of alias with double quote. Thanks to Carl Jackson for the report.
  • Fix some lines involuntary turned to comment. Thanks to Daniel Kukula for the report.
  • Fix CREATE DOMAIN formatting. Thanks to Daniel Kukula for the report.
  • Add formatting of code from SQL function.
  • Fix wrong indentation in ORDER BY clause. Thanks to Thom Brown for the report.
  • Fix CREATE TRIGGER formatting when there is a OR REPLACE clause. Thanks to hexcowboy for the report.
  • Fix documentation by using variable based installation instruction. Thanks to Lav Patel for the patch.
  • Add the possibility to format in place multiple files. Thanks to Benjamin Yolken for the report.