PostgreSQL: pgFormatter v5.3 released

NewsBot · 9 August 2022 08:05

A new PostgreSQL blog post/announcement has been posted!

Compiegne - August 07, 2022

pgFormatter 5.3 released

Version 5.3 of pgFormatter, a free and reliable tool used to format SQL and PLPGSQL code, has been officially released and is publicly available for download. A demonstration site is available online at http://sqlformat.darold.net/

pgFormatter 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 maintenance release fixes issues reported by users since the last six months. Here is the complete list of changes and acknowledgments:

Remove some useless parenthesis in DML statement.

Fix -o | --output that was always forced to stdout.

Add support to json operator ?|.

Fix formatting of create table with option and tablespace.

Fix wrong wrapping in create table when --nocomment was used.

Fix nested CREATE SCHEMA formatting.

Fix invalid multi-line string c...

Get the full details here: PostgreSQL: pgFormatter v5.3 released