PostgreSQL: pgFormatter v5.6 has been released

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

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 wit...

Get the full details here: PostgreSQL: pgFormatter v5.6 has been released