Skip to content

Version 3.0
Compare
Choose a tag to compare
@darold darold released this 28 Feb 18:24
· 518 commits to master since this release
v3.0
5f415a4

Febuary 28 2018 - v3.0

This major release fixes some issues reported by users during the
last six months and adds several new features.

  * Add colorization of comments.
  * Add detection and colorization of user defined function in the SQL
    code. Until now only PostgreSQL internal function was highlighted.
  * Add new option -B | --comma-break and in CGI the checkbox
    "New-line after comma (insert)" to force a newline after each
    comma in INSERT statements, columns and values parts.
  * Add command line option: -F | --format to be able to change the
    output format in CLI mode. At now there is two possible format,
    text the default or html. More format can be added in the future.
  * Add support to all psql meta commands up to v1O.

There is also some improvement in SQL code formatting.

The move to a new major release is related to the removing of the
html_highlight_code() method used to apply HTML formatting style.

If you are using your own custom scripts based on the pgFormatter
Perl modules this will break backward compatibility and you will
have to remove the call to html_highlight_code() in your script.
Here is the new synopsys for an HTML output:

   my $beautifier = pgFormatter::Beautify->new();
   $beautifier->query( 'select a,b,c from d where e = f' );
   $beautifier->format('html');
   $beautifier->beautify();
   my $nice_html = $beautifier->content();

Note that if you are using the pg_format script provided in the
pgFormatter release you don't have to care about this change.

For the complete list of changes see: https://github.com/darold/pgFormatter/blob/master/ChangeLog

Assets 2
Loading