PostgreSQL: pgFormatter v5.8 has been released

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

Dar Es Salam, Tanzania - September 14th, 2025

pgFormatter v5.8

pgFormatter, even if not perfect, is the most advanced SQL and PlPgsql code formatter and beautifier dedicated to PostgreSQL. It is provided as a CLI or a CGI program.

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

Here are the major improvements:

• Fix bad indentation for WHERE after JOIN.

• pgFormatter is now able to distinguish between single values and multiple values INSERT statement and to format them differently. Here an example of the output format for both:

  -- multiple values form
  INSERT INTO tempy_mc_tempface
  VALUES
      ('tempy'),
      ('mc'),
      ('tempface');
  – single values form
  
  INSERT INTO tempy_mc_tempface
  
  VALUES (‘another’, ‘world’);
  
  

• Fix indentation issue of INSERT statements in DO block.

• Fix wrong formatting of format() function placeholders.

For the complete list of changes, please checkout the release note on https://github.com/darold/pgFormatter/blob/master/ChangeLog

Links & Credits

Thank to the developers who submitted patches and users who reported bugs and feature requests, they are all cited in the ChangeLog file.

pgFormatter is an open project. Any contribution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools.

Links:

• Website: http://sqlformat.darold.net/
• Download: https://github.com/darold/pgFormatter/releases
• Development: https://github.com/darold/pgFormatter
• Changelog: https://www.postgresql.org/about/news/pgformatter-v58-has-been-released-3137/