pg_utl_smtp

pig build pkg pg_utl_smtp;		# build deb

pig repo add pgdg -u    # add pgdg repo and update cache

pig install pg_utl_smtp;		# install via package name, for the active PG version

pig install pg_utl_smtp -v 18;   # install for PG 18
pig install pg_utl_smtp -v 17;   # install for PG 17
pig install pg_utl_smtp -v 16;   # install for PG 16
pig install pg_utl_smtp -v 15;   # install for PG 15
pig install pg_utl_smtp -v 14;   # install for PG 14

CREATE EXTENSION pg_utl_smtp CASCADE; -- requires plperlu

CREATE EXTENSION plperlu;
CREATE EXTENSION pg_utl_smtp;

DO $$
DECLARE
    c utl_smtp.connection;
BEGIN
    c := utl_smtp.open_connection('smtp.example.com', 25);
    CALL utl_smtp.ehlo(c, 'mydomain.com');
    CALL utl_smtp.mail(c, '[email protected]');
    CALL utl_smtp.rcpt(c, '[email protected]');
    CALL utl_smtp.open_data(c);
    CALL utl_smtp.write_data(c, 'From: [email protected]' || E'\r\n');
    CALL utl_smtp.write_data(c, 'To: [email protected]' || E'\r\n');
    CALL utl_smtp.write_data(c, 'Subject: Test Email' || E'\r\n');
    CALL utl_smtp.write_data(c, E'\r\n');
    CALL utl_smtp.write_data(c, 'Hello from PostgreSQL!');
    CALL utl_smtp.close_data(c);
    CALL utl_smtp.quit(c);
END;
$$;

-- utl_smtp.connection composite type
(host varchar(255), port integer, tx_timeout integer,
 private_tcp_con integer, private_state integer)