Antananarivo, Madagascar - October 06, 2026 ## PostgreSQL UTL_SMTP compatibility extension
pg_utl_smtp is a PostgreSQL extension to create, manage and use Oracle-style UTL_SMTP package. The use and behavior is just like with the UTL_SMTP Oracle package. This work is released from the [HexaRocket](https://hexarocket.com) project. This extension allows email notifications to be sent from triggers or stored procedures. By integrating the extension directly into the database, you can trigger data-driven actions without waiting for application intervention. Examples include security alerts or notifications when certain minimum thresholds are reached. pg_utl_smtp v2.0.0 has been released, this new major version adds an asynchronous mode with setting `pg_utl_smtp.asynchronous` enabled. The Oracle version doesn't support asynchronous mode but this feature can be useful if you want to port the MSSQL sp_send_dbmail() procedure using pg_utl_smtp. Other changes in this release: - Raise an error when the SMTP server returns an error to HELO/EHLO, MAIL, RCPT, DATA, end of DATA or QUIT. - Fix duplicate EHLO sent at connection - Implement SSL/TLS connections (secure_connection_before_smtp). - QUIT releases the connection, a second QUIT raises an error. - When the connection can not be established the WARNING gives the reason. - Add regression tests by GitHub Actions. To upgrade an installed version 2.0.0 execute: ALTER EXTENSION pg_utl_smtp UPDATE; This extension uses plperl stored procedures based on the Net::SMTP Perl module to provide the procedures of the UTL_SMTP package. ## Links & Credits pg_utl_smtp is an open project under the PostgreSQL license created by Gilles Darold at [HexaCluster Corp.](https://hexacluser.ai/) as part of the [HexaRocket](https://hexarocket.com/) migration solution. Any contribution to build a better tool is welcome. You can send your ideas, features requests or patches using the GitHub tools. **Links :** * Download: [https://github.com/HexaCluster/pg_utl_smtp/releases/](https://github.com/HexaCluster/pg_utl_smtp/releases/) * Support: use GitHub report tool at [https://github.com/HexaCluster/pg_utl_smtp/issues](https://github.com/HexaCluster/pg_utl_smtp/issues) ## About pg_utl_smtp The pg_utl_smtp extension is an original work of [HexaCluster Corp.](https://hexacluster.ai/), HexaCluster is specialized in migration to PostgreSQL and PostgreSQL support. If you need more information please [contact us](https://hexacluster.ai/contact-us) Documentation at [https://github.com/HexaCluster/pg_utl_smtp#readme](https://github.com/HexaCluster/pg_utl_smtp#readme)
