pgFormatter 2.1 released
----------------------------------
Version 2.1 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 reported by users since four months.
It also adds some improvements in code formatting:
- Add support to new psql meta-command from v10.
- Add two command line option to defined where comma must appears
in a parameter list:
-b | --comma-start: in a parameters list, start with a comma (see -e)
-e | --comma-end : in a parameters list, end with a comma (default)
The CGI interface adds a new checkbox to force comma at beginning.
Default is lines end with a comma.
- Prevent dynamic code formatting. By default pgFormatter takes all
code between single quote as string constant and do not perform
any formatting on this code. It is common to use a string as
code separator to avoid doubling single quote in dynamic code
generation, in this case pgFormatter can fail to auto detect
the code separator. By default it will search for any string after
the EXECUTE keyword starting with dollar sign. If it can not auto
detect your code separator you can use the command line option -S
or --separator to set the code separator that must be used.
- Make it possible to run pg_format via symlink. For example, if
pgFormatter is in /opt/pgFormatter and there is a symlink like
/usr/local/bin/pg_format -> /opt/pgFormatter/pg_format
then previous version wouldn't work when called via symlink, as
it would search for libs in /usr/local/bin/lib/, and not in
/opt/pgFormatter/lib.
For the full list of changes, see:
Changelog: 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 Alvaro Herrera, fnwiya, Sebastian Albert,
Vesa Karjalainen, Fabian Zeindl, Huy Pham, Jakob Egger and Gajus Kuizinas
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
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 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
