...
In case it wasn't clear, this script is meant to view data, which implies SELECT. DonSo don't do stupid things like UPDATE or DELETE.
...
This is a problem with MailTweak, because it doesn't grok MIME encoding, so it will use this string verbatim in the mail header, which violates MIME specs, and the text will become garbage (as well as tripping spam filters upstreamwhich screw up the text (and trip upstream spam filters).
This can be fixed by using Perl's Encode::MIME::Header. I choose to do this from within PostgreSQL, but by adding the Perl procedural language. I needed to use the "unsafe" version, so that libraries can be used.
...