Well, it’s pretty rare that I get anyone talking about my old PostgreSQL email stored procedure, but here we are. I wrote this thing almost 25 years ago to essentially replicate the functionality of xp_sendmail into PostgreSQL. I released it to the world, because I knew other people would have this issue. And as it turned out, they absolutely do.

Thus, pgMail was born.

The history is all on Github now, and it’s generally been stable over the years. There were some bugs that needed to get fixed over time such as issues with SMTP Pipelining, adding support for MIME Multipart emails that would offer HTML formats as are the norm these days. But today I had someone request to turn on utf-8 encoding to ensure the expanded character set is processed properly. Surprised that had not been requested yet, but here we are.

That’s been released today with some additional updates to the README and sample code that reflects PostgreSQL v15+ installations. You can get all the details here.

This post originally appeared on BrandenWilliams.com.

Possibly Related Posts:


0