pgFormatter v5.6 has been released

Antananarivo, Madagascar - March 17th, 2025

pgFormatter v5.6

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 major release fixes issues reported by users since the last release with some improvements and new features.

New options and features:

• Add support to pg_vector operator <#>.
• Add support for the @? jsonb-jsonpath operator.
• Follow the XDG Base Directory Specification by searching configuration file into XDG_CONFIG_HOME/pg_format/config.conf.
• Check USERPROFILE env var for Windows.
• Add to_reg and reg to function list.
• Add missing Perl modules in installation instructions.
• Add information about the Perl module to install for the JSON feature.
• Expand web capabilities of the app with adding API-like JSON capability to the CGI module. The API can be disabled using the enable_api parameter to the CGI (default: 1).
• Add option --redundant-parenthesis to prevent pgFormatter to remove redundant parenthesis in DML.

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: https://sqlformat.darold.net/
• Download: https://github.com/darold/pgFormatter/releases
• Development: https://github.com/darold/pgFormatter
• Changelog: https://github.com/darold/pgFormatter/blob/master/ChangeLog

---

About pgFormatter

pgFormatter is a SQL and PlPgsql formatter/beautifier that supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. May works with any other databases too. It shares the same code with pgBadger, so any improvement made in the parser is reversed to pgBadger. Tool created and maintained by Gilles Darold.

pgFormatter works on any platform and is available under the PostgreSQL license.