30th September 2021: PostgreSQL 14 Released!

pgFormatter v5.0 released

Posted on 2021-02-14 by Gilles Darold
Related Open Source

Grenoble, France - February 11th, 2021

pgFormatter v5.0

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 major release fixes issues reported by users since the last six months with some improvements and new features.

New options and features:

  • Add new option -M | --multiline to enable multi-line search with placeholder regexp specified at command line with -p or --placeholder.
  • Fix improper handling of constants between quotes in all kind of queries and especially in function body. They were sometime corrupted by extra space before of after single quotes or some words was identified as keywords and turned upper case.
  • Add keywords ALWAYS, DISABLE, ENABLE, LEVEL and STORED.
  • Improve formatting of CREATE POLICY which doesn't the need anymore that alternate formatting (-t) be enabled.
  • More fix of false positive keywords detection following their place.
  • Add REGCLASS, REGCONFIG, REGDICTIONARY, REGNAMESPACE, REGOPER, REGOPERATOR, REGPROC, REGPROCEDURE, REGROLE, REGTYPE, to list of data types.

For the complete list of changes, please checkout the release note on 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.