Grenoble - January 11, 2023
Version 5.4 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 five months with some improvements and new features.
New options and features:
--no-space-function, when used pgFormatter removes the space character between a function call and the open parenthesis that follow. By default pgFormatter adds a space character, for example:
DROP FUNCTION IF EXISTS app_public.hello (a text);
DROP FUNCTION IF EXISTS app_public.hello(a text);
--extra-keywordto apply keywords formatting to a list of additional keywords defined in a file (one keyword per line). You can al so pass a special value 'redshift' instead of a path to a file to use the keywords defined internally in pgFormatter for this database. This was historically possible through the
-r | --redshiftoption that is now obsolete and will be removed in the future.
For the complete list of changes see: https://github.com/darold/pgFormatter/blob/master/ChangeLog
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.
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.