pgFormatter v5.10 has been released

Antananarivo, Madagascar - May 9th, 2026

## pgFormatter v5.10

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

Here are the major improvements:

- Add formatting of MERGE requests.
- Fix DO $$ BEGIN CREATE TABLE (...); END $$; an extra space was added to variable length types before closing parenthesis.
- Fix formatting issue in WHERE clause with CREATE POLICY.
- Add support to JSONB Array delete field operator format issue.
- Fix a RETURNING formatting issue in CTE when it include an INSERT INTO statement.
- Fix formatting of clause INTO vars with UPDATE.
- Fix indentation of RETURNING ... INTO statements.
- Preserve inline $$…$$ dollar-quoted strings with SQL function declaration.
- Fix indentation of SELECT ... INTO statements.
- Fix indentation levels in CREATE POLICY statements with USING and WITH CHECK.

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.