Re: Calling external programs

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
>