Обсуждение: Triggers
Hi, does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible? Uzo
beyaRecords - The home Urban music wrote: > does postgresql support the ability to email as in SQL Server? I want > to create a trigger which on input of a record will send out an > email. Is this possible? Write a trigger function in, say, PL/PerlU or PL/sh and have it send the email with the usual Perl or shell commands.
Dear Uzo , > Hi, > does postgresql support the ability to email as in SQL Server? I want > to create a trigger which on input of a record will send out an email. > Is this possible? http://pgmail.sourceforge.net/ is what you need. Regards, Vishal Kashyap
On Monday 12 January 2004 16:14, beyaRecords - The home Urban music wrote: > Hi, > does postgresql support the ability to email as in SQL Server? I want > to create a trigger which on input of a record will send out an email. > Is this possible? Have a look in the mailing list archives - this has been covered recently. I seem to recall there is an add-on that does just this. -- Richard Huxton Archonet Ltd
I try pgmail and that is well running ...
fo security, do not use attachment files with your mail ...
try pgmail, you need to use pl/tclu ...
Ben
fo security, do not use attachment files with your mail ...
try pgmail, you need to use pl/tclu ...
Ben
Sai Hertz And Control Systems wrote:
Dear Uzo ,Hi,
does postgresql support the ability to email as in SQL Server? I want to create a trigger which on input of a record will send out an email. Is this possible?
http://pgmail.sourceforge.net/ is what you need.
Regards,
Vishal Kashyap
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
I try pgmail and that is well running ... fo security, do not use attachment files with your mail ... try pgmail, you need to use pl/tclu ... Ben Sai Hertz And Control Systems wrote: > Dear Uzo , > >> Hi, >> does postgresql support the ability to email as in SQL Server? I want >> to create a trigger which on input of a record will send out an >> email. Is this possible? > > > http://pgmail.sourceforge.net/ is what you need. > > Regards, > > Vishal Kashyap > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >