Check out PGMail
len morgan
-----Original Message-----
From: Fran Fabrizio <ffabrizio@Exchange.WebMD.net>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Tuesday, June 05, 2001 12:14 PM
Subject: [GENERAL] Calling external programs
>
>Hello,
>
>I would like to call an external program from Pg. Specifically, I'd
>like to send an email every time a row with certain attribute values is
>inserted into a table. I already have a trigger that fires upon
>insertion into the table. Is the preferred method to have a trigger
>call a procedure written in say PLPERL? Is PLPERL capable of calling
>external programs or better yet forming the mail and calling sendmail
>itself?
>
>Thanks,
>Fran
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>