pg_smtp_client

pig build pkg pg_smtp_client         # build RPM / DEB packages

pig repo add pgsql -u          # Add repo and update cache

CREATE EXTENSION pg_smtp_client;

CREATE EXTENSION IF NOT EXISTS pg_smtp_client CASCADE;

ALTER SYSTEM SET smtp_client.server TO 'smtp.example.com';
ALTER SYSTEM SET smtp_client.port TO 587;
ALTER SYSTEM SET smtp_client.tls TO true;
ALTER SYSTEM SET smtp_client.username TO 'MySmtpUsername';
ALTER SYSTEM SET smtp_client.password TO 'MySmtpPassword';
ALTER SYSTEM SET smtp_client.from_address TO '[email protected]';
SELECT pg_reload_conf();

SELECT smtp_client.send_email('test subject', 'test body', false, '[email protected]', array['[email protected]'], null, null, 'smtp.example.com', 587, true, 'username', 'password');

SELECT smtp_client.send_email('test subject', 'test body', false, null, array['[email protected]']);

SELECT smtp_client.send_email('test subject', 'test body', recipients => array['[email protected]']);