Content-Type: multipart/alternative;
 boundary="===============5442245339083268644=="
MIME-Version: 1.0
Subject: pgfmt 2.1: in-place formatting and pg_dump-compatible output
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
From: "Gavin M. Roy via PostgreSQL Announce" <announce-noreply@postgresql.org>
Reply-To: gavinmroy@gmail.com
Date: Thu, 18 Jun 2026 19:03:22 +0000
Message-ID: <178180940244.774.1804930164641759759@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/178180940244.774.1804930164641759759%40wrigleys.postgresql.org>
Precedence: bulk

--===============5442245339083268644==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

[pgfmt](https://gmr.github.io/pgfmt/) 2.1 lands two headline features, plus=
 a steady stream of formatting coverage improvements driven by libpgfmt. It=
 is also now installable from a Homebrew tap.

# Install via Homebrew

`brew tap gmr/pgfmt && brew install pgfmt`

The install script, cargo install pgfmt, and [prebuilt release binaries](ht=
tps://github.com/gmr/pgfmt/releases/tag/v2.1.7) all remain available.

# In-place formatting

`--inplace` / `-i` writes formatted output back to the source file instead =
of stdout, preserving the original file permissions. It takes multiple file=
s:

`pgfmt -i query1.sql query2.sql`

# pg_dump style

`pgfmt --style pg_dump` (aliases `pgdump`, `postgres`) reproduces PostgreSQ=
L's `ruleutils.c` deparser layout, the output you get from `pg_get_viewdef`=
 and `pg_get_functiondef`. On genuine deparser output it is byte-idempotent=
: format a catalog dump and you get the same bytes back. Useful for diffing=
 migrations against what PostgreSQL actually stores.

# Other improvements

The 2.1.x line also expanded formatting coverage across SQL and PL/pgSQL an=
d fixed several correctness bugs, including typed string literals `(INTERVA=
L '2 days')` that were previously dropped. Catalog-dumped views and
functions that used to fail now format cleanly.=20

[See the release notes for the full list](https://github.com/gmr/pgfmt/rele=
ases).
--===============5442245339083268644==
Content-Type: text/html; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


<!doctype html>
<html>
  <head>
    <meta name=3D"viewport" content=3D"width=3Ddevice-width">
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8=
">
    <title>pgfmt 2.1: in-place formatting and pg_dump-compatible output</ti=
tle>
    <style>

    @media only screen and (max-width: 620px) {
      table[class=3Dbody] h1 {
        font-size: 28px !important;
        margin-bottom: 10px !important;
      }
      table[class=3Dbody] p,
            table[class=3Dbody] ul,
            table[class=3Dbody] ol,
            table[class=3Dbody] td,
            table[class=3Dbody] span,
            table[class=3Dbody] a {
        font-size: 16px !important;
      }
      table[class=3Dbody] .wrapper,
            table[class=3Dbody] .article {
        padding: 10px !important;
      }
      table[class=3Dbody] .content {
        padding: 0 !important;
      }
      table[class=3Dbody] .container {
        padding: 0 !important;
        width: 100% !important;
      }
      table[class=3Dbody] .main {
        border-left-width: 0 !important;
        border-radius: 0 !important;
        border-right-width: 0 !important;
      }
      table[class=3Dbody] .btn table {
        width: 100% !important;
      }
      table[class=3Dbody] .btn a {
        width: 100% !important;
      }
      table[class=3Dbody] .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=3D"" style=3D"background-color: #f6f6f6; font-family: sans-se=
rif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4=
; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adju=
st: 100%;">
    <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" class=3D"body" =
style=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace=
: 0pt; width: 100%; background-color: #f6f6f6;">
      <tr>
        <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali=
gn: top;">&nbsp;</td>
        <td class=3D"container" style=3D"font-family: sans-serif; font-size=
: 14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580=
px; padding: 10px; width: 580px;">
          <div class=3D"content" style=3D"box-sizing: border-box; display: =
block; Margin: 0 auto; max-width: 580px; padding: 10px;">


            <span class=3D"preheader" style=3D"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=3D"main" style=3D"border-collapse: separate; mso-t=
able-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: #ffffff; =
border-radius: 3px;">


              <tr>
                <td class=3D"wrapper" style=3D"font-family: sans-serif; fon=
t-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;">
                  <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" s=
tyle=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace:=
 0pt; width: 100%;">
                    <tr>
                      <td style=3D"font-family: sans-serif; font-size: 14px=
; vertical-align: top;">

<div>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">pgfmt 2.1: in-place formatting and pg_dump-compatible output</h1>
</div>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><a href=3D"https://gmr.github.io/pgfmt/" st=
yle=3D"color: #3498db; text-decoration: underline">pgfmt</a> 2.1 lands two =
headline features, plus a steady stream of formatting coverage improvements=
 driven by libpgfmt. It is also now installable from a Homebrew tap.</p>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">Install via Homebrew</h1>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><code>brew tap gmr/pgfmt &amp;&amp; brew in=
stall pgfmt</code></p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">The install script, cargo install pgfmt, an=
d <a href=3D"https://github.com/gmr/pgfmt/releases/tag/v2.1.7" style=3D"col=
or: #3498db; text-decoration: underline">prebuilt release binaries</a> all =
remain available.</p>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">In-place formatting</h1>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><code>--inplace</code> / <code>-i</code> wr=
ites formatted output back to the source file instead of stdout, preserving=
 the original file permissions. It takes multiple files:</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><code>pgfmt -i query1.sql query2.sql</code>=
</p>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">pg_dump style</h1>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><code>pgfmt --style pg_dump</code> (aliases=
 <code>pgdump</code>, <code>postgres</code>) reproduces PostgreSQL's <code>=
ruleutils.c</code> deparser layout, the output you get from <code>pg_get_vi=
ewdef</code> and <code>pg_get_functiondef</code>. On genuine deparser outpu=
t it is byte-idempotent: format a catalog dump and you get the same bytes b=
ack. Useful for diffing migrations against what PostgreSQL actually stores.=
</p>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">Other improvements</h1>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">The 2.1.x line also expanded formatting cov=
erage across SQL and PL/pgSQL and fixed several correctness bugs, including=
 typed string literals <code>(INTERVAL '2 days')</code> that were previousl=
y dropped. Catalog-dumped views and
functions that used to fail now format cleanly. </p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px"><a href=3D"https://github.com/gmr/pgfmt/rel=
eases" style=3D"color: #3498db; text-decoration: underline">See the release=
 notes for the full list</a>.</p>

                      </td>
                    </tr>
                  </table>
                </td>
              </tr>

            </table>

            <div class=3D"footer" style=3D"clear: both; Margin-top: 10px; t=
ext-align: center; width: 100%;">
              <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" style=
=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt=
; width: 100%;">
                <tr>
                  <td class=3D"content-block" style=3D"font-family: sans-se=
rif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-siz=
e: 12px; color: #999999; text-align: center;">
                    <span class=3D"apple-link" style=3D"color: #999999; fon=
t-size: 12px; text-align: center;">
This email was sent to you from Gavin M. Roy. It was delivered on their beh=
alf by
the PostgreSQL project. Any questions about the content of the message shou=
ld be
sent to Gavin M. Roy.
</span>
		    <br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mai=
linglist, for
the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click th=
e personal unsubscribe
link that you can find in the headers of this email, or visit
<a href=3D"https://lists.postgresql.org/unsubscribe/" style=3D"color: #3498=
db; text-decoration: underline">https://lists.postgresql.org/unsubscribe/</=
a>.

                  </td>
                </tr>
              </table>
            </div>

          </div>
        </td>
        <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali=
gn: top;">&nbsp;</td>
      </tr>
    </table>
  </body>
</html>

--===============5442245339083268644==--