Sending email from PL/pgsql

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:

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 #