pgFormatter v5.3 released

Compiegne - August 07, 2022

##pgFormatter 5.3 released

Version 5.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
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 maintenance release fixes issues reported by users since the last six
months. Here is the complete list of changes and acknowledgments:

- Remove some useless parenthesis in DML statement.
- Fix -o | --output that was always forced to stdout.
- Add support to json operator ?|.
- Fix formatting of create table with option and tablespace.
- Fix wrong wrapping in create table when --nocomment was used.
- Fix nested CREATE SCHEMA formatting.
- Fix invalid multi-line string constant formatting.
- Force multiple INSERT values to be on separate lines. Previous behavior was to keep all values on the same line.
- Add missing ELSIF keyword.
- Fix bad indentation when INDEX is present in target list.

For the complete list of changes see: [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/)
- Download1: [https://github.com/darold/pgFormatter/releases](https://github.com/darold/pgFormatter/releases)
- Download2: [http://sourceforge.net/projects/pgformatter/](http://sourceforge.net/projects/pgformatter/)
- 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 licence.