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 -- Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-announce