Re: [HACKERS] sending mail from Postgres

2005-12-28 Thread Jeremy Drake
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

Re: [HACKERS] sending mail from Postgres

2005-12-28 Thread David Fetter
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, D

[HACKERS] sending mail from Postgres

2005-12-27 Thread Aftab Alam
Hi there, How can i send mail form postgresql. any suggestion. thanx regards aftab ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] sending mail from Postgres

2005-12-27 Thread Pavel Stehule
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