On Wed, Dec 28, 2005 at 08:52:41AM +0530, Aftab Alam wrote:
> Hi there,
>
> How can i send mail form postgresql.
Generally, it is a better idea either to poll your PostgreSQL database
and send mail based on that, or use LISTEN/NOTIFY, rather than
directly sending mail from your database.
Cheers,
Code from perl cookbook, wrapped in plperlu wrapper
not very portable, Net::SMTP would probably be better, and result in more
portable perl code.
Didn't test this - but it is copied straight from perl cookbook via
google: http://www.unix.org.ua/orelly/perl/cookbook/ch18_04.htm
CREATE OR REPLACE
Hello,
it depend on your possibilities. Simply, use PL/Perl or PL/sh.
Regards
Pavel Stehule
or use PgSendMail
http://sourceforge.net/project/showfiles.php?group_id=35804
Hi there,
How can i send mail form postgresql.
any suggestion.
thanx & regards
aftab
---(end of
Hi there,
How can i send mail form postgresql.
any suggestion.
thanx & regards
aftab
---(end of broadcast)---
TIP 6: explain analyze is your friend