github darold/pgFormatter v5.9
Version 5.9

6 hours ago

December 21 2025 - v5.9

This release adds several formatting improvements and fixes some issues
reported by users since the last release.

Here is the complete list of changes and acknowledgments:

  • Fix wierd nested indenting when using multi conditional join with integer 0
    value. Thanks to Neszt Tibor for the report.
  • Fix bad indentation with simple join. Thanks to anttilinno for the report.
  • Fix indentation after RAISE EXCEPTION ... USING. Thanks to Ray Ng for the
    report.
  • Fix bad formatting in CASE statements with variable assignments. Thanks to
    Serhii Khoma for the report.
  • Limit the number of perl version tested
  • Add CI action to test pgFormatter on commit push
  • Fix dollar quote sign when attached to a word. Thanks to Andrew Jackson for
    the report.
  • Fix indentation of UNION in RETURN QUERY clause. Thanks to birgersp for the
    report.
  • Fix false negative in keyword detection with QUERY after RETURN
  • Add pre-commit hook config. Thanks to Alexey Shrub for the patch.
  • Add extra newline after ariga/atlas related comment line. Thanks to Jay Babu
    for the feature request.
  • Fix incorrect formatting in PL/pgSQL when using DECLARE and CASE. Thanks to
    lkslawek for the report.
  • Fix incorrect formatting of scientific notation with exponents. Thanks to
    Ray Ng for the report. Add regression tests cases.
  • Fix incorrectly removing extra parenthesis in CREATE POLICY statements.
    Thanks to Julian Niedermeier for the report.

Don't miss a new pgFormatter release

NewReleases is sending notifications on new releases.