pgFormatter 1.6 released
------------------------
January 23 2017 - v1.6
This release fixes several issues and adds lot of improvements in
query formatting.
Command line option --placeholder or -p has been added to be able
to set regex to find code that must not be formatted. For example,
in query like:
SELECT * FROM projects WHERE projectnumber
IN <<internalprojects>> AND username = <<loginname>>;
you may want pgFormatter to not interpret << and >> as bit-shift
keywords and modify your code snippsets. You can use a Perl regular
expression to instruct pgFormatter to keep some part of the query
untouched. For example:
pg_format samples/ex9.sql -p '<<(?:.*)?>>'
will not format the bit-shift like operators.
pgFormatter v1.6 is available as a free online service for queries
up to 100 Kb at http://sqlformat.darold.net/. To see a sample of SQL
formatting provided by pgFormatter and compare with other tools
click the "Load an example" and "Format my code" buttons.
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, especially Laurenz Albe, Julien Rouhaud,
clijunky, jhelberg and Pilat66.
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/
Download: 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 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 can work as a console program or as a CGI. It will
automatically detect his environment and output as text or as HTML
following the context.
pgFormatter works on any platform and is available under the
PostgreSQL licence.
--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org