Make Homepage | Add To Favorites | Print Page | Submit News | Feedback | Contact | 

Your Technical Computer Information Resource!  
     
  Technical Updates @ TACKtech Corp.  

10.17.2015 - pgFormatter 1.5 released



View PostgreSQL-Press related news.

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.

Links:

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.



- Download PostgreSQL
- View Press Release
- Visit PostgreSQL

NID: 56470 / Submitted by: The Zilla of Zuron
Categories: Server Applications, Open Source, Press Release
Most recent PostgreSQL-Press related news.
Announcement: Amazon RDS for PostgreSQL Enhancements: Support for new minor versions, Logical Replication, and Amazon RDS PostgreSQL as a source for AWS DMS
PostgreSQL PHP Generator 16.9 released
JDBC 1211 released
PGLiveBackup Beta 1 Released
Aiven brings easy, powerful hosted PostgreSQL to Microsoft Azure
View archive of PostgreSQL-Press related news.

Visit the TACKtech Shop
  Popular Tech News  
  Most Viewed News  
  Top Affiliates  
........