MIME-Version: 1.0
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 27 Aug 2025 11:27:51 -0400
Message-ID: <CANzqJaAJVQVa0Wbx1fHv5n7zfp9ZyCXZMPqJF_JLTBo68ToNeA@mail.gmail.com>
Subject: psql --html and to_char()
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000329bc8063d5a6fe4"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAJVQVa0Wbx1fHv5n7zfp9ZyCXZMPqJF_JLTBo68ToNeA%40mail.gmail.com>
Precedence: bulk

--000000000000329bc8063d5a6fe4
Content-Type: text/plain; charset="UTF-8"

PG 17, if relevant.

It's great that "psql --html" adds align="right" to numeric fields.  But...
psql understandably forgets that when the numeric field is passed to
to_char().

Is there a way around this, other than writing my own HTMLifier?

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000329bc8063d5a6fe4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>PG 17, if relevant.</div><div><br></div><div>It&#39;s=
 great that &quot;psql --html&quot; adds=C2=A0align=3D&quot;right&quot; to =
numeric fields.=C2=A0 But... psql understandably forgets that when the nume=
ric field is passed to to_char().</div><div><br></div><div>Is there a way a=
round this, other than writing my own HTMLifier?</div><div><br></div><span =
class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gm=
ail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr">Death to=
 &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still a=
live.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div><=
/div>

--000000000000329bc8063d5a6fe4--