Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wMRZF-0005w9-2W for pgsql-announce@arkaria.postgresql.org; Mon, 11 May 2026 14:25:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wMRZE-0015x2-1W for pgsql-announce@arkaria.postgresql.org; Mon, 11 May 2026 14:25:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wMRYI-000tWT-1e for pgsql-announce@lists.postgresql.org; Mon, 11 May 2026 14:24:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wMRYE-000000003a7-0uE5 for pgsql-announce@lists.postgresql.org; Mon, 11 May 2026 14:24:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=27IlkLv3hjnlc3T7oRik6pXxZneYQbbGBnbGeBmREoA=; b=s9ti6IR/Uc8vEfCgGoKLbmF1Go 5uwzrxAjqtSPDGV4D7tqnXYcqM9AQqU7DT2rbjacOGRAWxDnp7usVtnbnxPAS12XxW2STEsAKrfC+ RUXSjUeYXnuYNlon9fVKjnbBq5/mHTpoefwQkYY6q13EttXbERO4OVth3WActlovtH3g6E+qhNyTV I1IHQS9XgoSLGja/urCjoTe4XwsqXqYy8DH7yDXwi5TWcAsm8ymkSkSntA7+YKLm7HBrxHwcNB2co HayI77zA/N0LXFKcg+4oE8W94qBfGgty0f/WFFZcWrtVdbqoR0XmPAvhZvZYE5d46J3vqycvnYcFx 8z4hm0jw==; Received: from wrigleys.postgresql.org ([217.196.149.60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wMRYC-0008EO-1v for pgsql-announce@lists.postgresql.org; Mon, 11 May 2026 14:24:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wMRY9-000K8u-2d for pgsql-announce@lists.postgresql.org; Mon, 11 May 2026 14:24:02 +0000 Content-Type: multipart/alternative; boundary="===============8838109322783126129==" MIME-Version: 1.0 Subject: pgFormatter v5.10 has been released To: PostgreSQL Announce From: HexaCluster via PostgreSQL Announce Reply-To: gilles@hexacluster.ai Date: Mon, 11 May 2026 14:23:58 +0000 Message-ID: <177850943805.848.15603110571826019896@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: 88774a5535756b510c44964f19082de5003e7167fc936eb22429c953d3bb6de8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8838109322783126129== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable 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 v= ariable 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 st= atement. - Fix formatting of clause INTO vars with UPDATE. - Fix indentation of RETURNING ... INTO statements. - Preserve inline $$=E2=80=A6$$ dollar-quoted strings with SQL function dec= laration. - Fix indentation of SELECT ... INTO statements. - Fix indentation levels in CREATE POLICY statements with USING and WITH CH= ECK. For the complete list of changes, please checkout the release note on [https://github.com/darold/pgFormatter/blob/master/ChangeLog](https://gi= thub.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/d= arold/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. --===============8838109322783126129== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable pgFormatter v5.10 has been released
 

pgFormatter v5.10 has been released

Antananarivo, Madagascar - May 9th, 2026

pgFormatter v5.10

pgFormatter, even if not perfect, is the mo= st 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 improv= ements 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 ty= pes 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= $$=E2=80=A6$$ 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 ch= eckout the release note on https://github.com/dar= old/pgFormatter/blob/master/ChangeLog

Links & Credits

Thank to the developers who submitted patch= es and users who reported bugs and feature requests, they are all cited in the ChangeLog file.

pgFormatter is an open project. Any contrib= ution to build a better tool is welcome. You just have to send your ideas, features requests or patches using the GitHub tools.

Links:

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 av= ailable under the PostgreSQL license.
This email was sent to you from HexaCluster. It was delivered on their beha= lf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to HexaCluster.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============8838109322783126129==--