pgFormatter 4.3 released

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

pgFormatter 4.3 released

Gilles Darold-2
Grenoble - Marsh 29th, 2020

**pgFormatter 4.3 released**

Version 4.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

pgFormatter is the most advanced SQL and PlPgsql code formatter and
beautifier dedicated to PostgreSQL. It is provided as a CLI or a CGI

This is a maintenance release to fix issues reported by users since
the last two months. As usual there is also some improvements and
more formatting supported.

New option:

  * Add command line option -r | --redshift to add RedShift specific
    keywords to the list of SQL keywords to format.
  * Add command line option -N | --numbering to include statement
    numbering. All formatted statements or block of code are prefixed
    by a line with comment: /* Statement # n */.
    Also available in CGI mode as a select box option.

Backward compatibility:

  * Keep simple quote as function code delimiter, previous behavior
    was to replace them by $$ and replace all double simple quote in
    the code by a single one. Now they are kept unchanged.
  * Restore formatting of --comma-break option with INSERT statement, a
    regression was introduced in version 4.2.

For the complete list of changes see:

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.



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.

Gilles Darold