pgFormatter v4.1 released - Mailing list pgsql-announce

Pemuteran, Bali - September 20th, 2019


**pgFormatter 4.1 released**

Version 4.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 three months. As usual there is also some improvements and
new features.


   * Add -T, --tabs option to make pg_format use tabs instead of space
     characters.  When this option is used spaces number is set to 1
     whatever is the value set to -s, --spaces.

   * Allow output to override source file.

   * Add option -g, --no-grouping and CGI corresponding checkbox. By
     default pgFormatter groups all statements when they are in a
     transaction:

         BEGIN;
         INSERT INTO foo VALUES (1, 'text 1');
         INSERT INTO foo VALUES (2, 'text 2');
         ...
         COMMIT;

     By disabling grouping of statement pgFormatter will always add an extra
     newline characters between statements just like outside a transaction:

         BEGIN;

         INSERT INTO foo VALUES (1, 'text 1');

         INSERT INTO foo VALUES (2, 'text 2');
         ...

         COMMIT;

     This might add more readability to not DML transactions.

   * Add more SQL keyword: REFRESH, MATERIALIZED, EVENT and function
     xmltable
   * Prevent uppercase of keywords when they are used as column names
     in a CREATE TABLE statement.

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:

     Website: http://sqlformat.darold.net/
     Download1: https://github.com/darold/pgFormatter/releases
     Download2: http://sourceforge.net/projects/pgformatter/
     Development: https://github.com/darold/pgFormatter
     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.

-- 
Gilles Darold
http://www.darold.net/