[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: pgFormatter v5.5 released
From: MigOps via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2023-02-07 12:49:36
Message-ID: 167577417679.1704774.3205962153173639225 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Lome, Togo - February 04, 2023
##pgFormatter 5.5 released
Version 5.5 of pgFormatter, a free and reliable tool used to format
SQL and PL/pgSQL code, has been officially released and is publicly
available for download. A demonstration site is available online at
http://sqlformat.darold.net/
pgFormatter is the most advanced SQL and PL/pgSQL code formatter and
beautifier dedicated to PostgreSQL. It is provided as a CLI or a CGI
program.
This maintenance release fixes some issues reported by users since the last
month and some improvements:
* Prevent newline in function supporting the FROM keyword like substring(=
).
* Add multi-line formatting on TRUNCATE with a table list.
For the complete list of changes see: [https://github.com/darold/pgFormatte=
r/blob/master/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, 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](http://sqlformat.darold.net/)
- Download1: [https://github.com/darold/pgFormatter/releases](https://githu=
b.com/darold/pgFormatter/releases)
- Download2: [http://sourceforge.net/projects/pgformatter/](http://sourcefo=
rge.net/projects/pgformatter/)
- Development: [https://github.com/darold/pgFormatter](https://github.com/d=
arold/pgFormatter)
- Changelog: [https://github.com/darold/pgFormatter/blob/master/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 license.
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>pgFormatter v5.5 released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: \
center">pgFormatter v5.5 released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Lome, Togo - February 04, 2023</p> <h2 style="color: #000; \
font-family: sans-serif; font-weight: 400; line-height: 1.4; margin: 0; \
margin-bottom: 30px">pgFormatter 5.5 released</h2> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Version 5.5 of \
pgFormatter, a free and reliable tool used to format SQL and PL/pgSQL code, has been \
officially released and is publicly available for download. A demonstration site is \
available online at http://sqlformat.darold.net/</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">pgFormatter is the most advanced SQL and PL/pgSQL code formatter \
and beautifier dedicated to PostgreSQL. It is provided as a CLI or a CGI
program.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">This maintenance release fixes some issues reported by users \
since the last month and some improvements:</p>
<ul style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: \
5px">Prevent newline in function supporting the FROM keyword like substring().</li> \
<li style="list-style-position: inside; margin-left: 5px">Add multi-line formatting \
on TRUNCATE with a table list.</li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">For the complete list of changes see: <a \
href="https://github.com/darold/pgFormatter/blob/master/ChangeLog" style="color: \
#3498db; text-decoration: \
underline">https://github.com/darold/pgFormatter/blob/master/ChangeLog</a></p> <h2 \
style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Links & Credits</h2> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px">Thank to the developers who submitted patches and users who reported bugs and \
feature requests, they are all cited in the ChangeLog file.</p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">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.</p>
<h3 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">Links:</h3> <ul style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px"> <li \
style="list-style-position: inside; margin-left: 5px">Website: <a \
href="http://sqlformat.darold.net/" style="color: #3498db; text-decoration: \
underline">http://sqlformat.darold.net</a></li> <li style="list-style-position: \
inside; margin-left: 5px">Download1: <a \
href="https://github.com/darold/pgFormatter/releases" style="color: #3498db; \
text-decoration: underline">https://github.com/darold/pgFormatter/releases</a></li> \
<li style="list-style-position: inside; margin-left: 5px">Download2: <a \
href="http://sourceforge.net/projects/pgformatter/" style="color: #3498db; \
text-decoration: underline">http://sourceforge.net/projects/pgformatter/</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Development: <a \
href="https://github.com/darold/pgFormatter" style="color: #3498db; text-decoration: \
underline">https://github.com/darold/pgFormatter</a></li> <li \
style="list-style-position: inside; margin-left: 5px">Changelog: <a \
href="https://github.com/darold/pgFormatter/blob/master/ChangeLog" style="color: \
#3498db; text-decoration: \
underline">https://github.com/darold/pgFormatter/blob/master/ChangeLog</a></li> </ul>
<h2 style="color: #000; font-family: sans-serif; font-weight: 400; line-height: 1.4; \
margin: 0; margin-bottom: 30px">About pgFormatter</h2> <p style="font-family: \
sans-serif; font-size: 14px; font-weight: normal; margin: 0; margin-bottom: \
15px">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.</p>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">pgFormatter works on any platform and is available under the \
PostgreSQL license.</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from MigOps. It was delivered on \
their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to MigOps.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic