30th September 2021: PostgreSQL 14 Released!

pgFormatter v5.1 has been released

Posted on 2021-09-28 by Gilles Darold
Related Open Source

Grenoble - September 28th, 2021

pgFormatter 5.1 released

Version 5.1 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 is a maintenance release to fix issues reported by users since the last six months. As usual there is also some improvements and new features.

  • Alternate format type (option -t) now keep enumeration in GROUP BY clause on a single line.
  • Add new option -k or --keep-newline to preserve empty line in plpgsql code.
  • Look for .pg_format configuration file in local directory first then in the $HOME directory.
  • Force UTF8 encoding for all I/O to solve unicode character in object name parsing issues.

For the complete list of changes see: 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:

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