pgFormatter 3.4 released - Mailing list pgsql-announce
From | Gilles Darold |
---|---|
Subject | pgFormatter 3.4 released |
Date | |
Msg-id | 63e099d4-5465-c938-21f1-161714086220@darold.net Whole thread Raw |
List | pgsql-announce |
Grenoble, France - April 21th, 2019 **pgFormatter 3.4 released** Version 3.4 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 avaliable online at http://sqlformat.darold.net/ This release fixes several issues reported by users since the last six months and adds lot of improvements in code formatting: * Add -W, --wrap-after option to set number of column after which lists must be wrapped. Default is to puts every item on its own line. * Add 'Wrap after' option to CGI in the indentation section to support the -W | --wrap_atfer command line option in CGI mode. * Add -w | --wrap-limit command line option to be able to to wrap queries at a certain length. This option is not available in CGI mode. * Allow uploaded file content-type to be application/octet-stream. * Allow a single $ sign in object name. * Major optimization of function detection, speed difference is 10 time faster. * Better detection of function versus keyword with same name. * Add WORK, GENERATED and IDENTITY as PostgreSQL keyword. * Add array_remove and array_replace to the list of PostgreSQL functions. * Add detection of code separator after DO keyword if it starts with a dollar sign. * Add new option -t | --format-type to try another formatting type for some statements. At this stage it will just use a multi-line format in POLICY and PUBLICATION statements. It also introduce newline in parameter function list. * Add formatting of CREATE POLICY statements. * Add information about (Neo)vim plugin and Visual Studio use of pgFormatter to format PLPGSQL and SQL code. 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/
pgsql-announce by date: