public inbox for [email protected]  

help / color / mirror / Atom feed

From: HexaCluster via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: pgFormatter v5.8 has been released
Date: Sun, 14 Sep 2025 13:34:05 +0000
Message-ID: <[email protected]> (raw)

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](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/](http://sqlformat.darold.net/)
* Download: [https://github.com/darold/pgFormatter/releases](https://github.com/darold/pgFormatter/releases)
* Development: [https://github.com/darold/pgFormatter](https://github.com/darold/pgFormatter)
* Changelog: [https://github.com/darold/pgFormatter/blob/master/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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgFormatter v5.8 has been released
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox