Thread: Sending email from PL/pgsql
Hey, I was wondering if it is possible to send email from within PL/pgsql. I'd like to do this to avoid code duplication in multiple frontends. Can this be done somehow? Or do I have to write a C function for this purpose? If so, how does one go about that? Thanks, -- Alexander Deruwe - aderuwe@aqs-carcontrol.be AQS-CarControl
Alexander Deruwe wrote: > I was wondering if it is possible to send email from within PL/pgsql. > I'd like to do this to avoid code duplication in multiple frontends. > Can this be done somehow? Or do I have to write a C function for this > purpose? If so, how does one go about that? You can write a postgresql function in C that calls libesmtp to send mails. http://www.stafford.uklinux.net/libesmtp/ Shridhar
Hello You can use PgSendMail http://sourceforge.net/project/showfiles.php?group_id=35804 Pavel On Thu, 30 Oct 2003, Alexander Deruwe wrote: > Hey, > > I was wondering if it is possible to send email from within PL/pgsql. > I'd like to do this to avoid code duplication in multiple frontends. > Can this be done somehow? Or do I have to write a C function for this > purpose? If so, how does one go about that? > > Thanks, > >
Alexander Deruwe wrote: >Hey, > >I was wondering if it is possible to send email from within PL/pgsql. >I'd like to do this to avoid code duplication in multiple frontends. >Can this be done somehow? Or do I have to write a C function for this >purpose? If so, how does one go about that? > > You can do it from pgperl and you can call a pgperl fruntion from pl/pgsql.
Hi, Alexander Deruwe schrieb: > Hey, > > I was wondering if it is possible to send email from within PL/pgsql. > I'd like to do this to avoid code duplication in multiple frontends. > Can this be done somehow? Or do I have to write a C function for this > purpose? If so, how does one go about that? > And to make it complete, now that plpython is unrestricted, you can also use plpythonu for this tasks. Works very well since this was one of the tests I had to make just after I got my hands on plpythonu ;-) For example including query results as attachment appeals to me. Regards Tino
On Thu, 2003-10-30 at 08:11, Tino Wildenhain wrote: > Hi, > > Alexander Deruwe schrieb: > > Hey, > > > > I was wondering if it is possible to send email from within PL/pgsql. > > I'd like to do this to avoid code duplication in multiple frontends. > > Can this be done somehow? Or do I have to write a C function for this > > purpose? If so, how does one go about that? > > > > And to make it complete, now that plpython is unrestricted, > you can also use plpythonu for this tasks. Works very well > since this was one of the tests I had to make just after > I got my hands on plpythonu ;-) > Actually you guys left out pltclu which can do it, code can be found in the cookbook: http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=292 Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Tino Wildenhain wrote: > Hi, > > Alexander Deruwe schrieb: >> Hey, >> >> I was wondering if it is possible to send email from within PL/pgsql. >> I'd like to do this to avoid code duplication in multiple frontends. >> Can this be done somehow? Or do I have to write a C function for this >> purpose? If so, how does one go about that? >> > > And to make it complete, now that plpython is unrestricted, > you can also use plpythonu for this tasks. Works very well > since this was one of the tests I had to make just after > I got my hands on plpythonu ;-) Complete? You forgot PL/TclU at least ;-) Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #