Re: Calling external programs

Check out PGMail

len morgan

-----Original Message-----
From: Fran Fabrizio <ffabrizio(at)Exchange(dot)WebMD(dot)net>
To: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)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
>