October 17 2015 - v1.5
Version 1.5 of pgFormatter, a free a SQL formatter/beautifier
dedicated to standard SQL and PostgreSQL specifics keywords, has
been officially released and is publicly available for download.
This release fixes several issues and adds support to new keywords
added in PostgreSQL 9.5. There's also a major code rewrite by Hubert
depesz Lubaczewski, pg_format works as previously - handles both CGI
and CLI interface, but you can get directly to whatever functionality
you want by using pgFormatter::* modules.
New beautified keywords are: BERNOULLI, CUBE, GROUPING SETS, SKIP
LOCKED, LOGGED, POLICY, ROLLUP, TABLESAMPLE. And new functions are:
jsonb_pretty, jsonb_set, pg_last_committed_xact, pg_xact_commit_timestamp.
There is also a useful hint added to documentation to be able to
format you SQL code from vi by adding a simple line to .vimrc. This
hint is taken from David Fetter's blog.
For the complete list of changes see the changelog.
Links & Credits
Thank to the developers who submitted patches and users who reported
bugs and feature requests, especially Hubert depesz Lubaczewski,
Kevin Brannen, David Fetter, Tom Burnett, Adrian Klaver, Alvaro
Herrera, Niklas Schmidtmer and Pablo Alvarez de Sotomayor Posadillo.
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 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
- Download PostgreSQL
- View Press Release
- Visit PostgreSQL