Обсуждение: 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
<br /><div class="moz-text-flowed" lang="x-western" style="font-family: -moz-fixed; font-size: 12px;">I try pgmail and thatis well running ... <br /> fo security, do not use attachment files with your mail ... <br /><br /> try pgmail, you needto use pl/tclu ... <br /><br /> Ben</div><br /><br /> Sai Hertz And Control Systems wrote:<br /><blockquote cite="mid4002CFAE.10408@sancharnet.in"type="cite">Dear Uzo , <br /><br /><blockquote type="cite">Hi, <br /> does postgresqlsupport the ability to email as in SQL Server? I want to create a trigger which on input of a record will sendout an email. Is this possible? <br /></blockquote><br /><a class="moz-txt-link-freetext" href="http://pgmail.sourceforge.net/">http://pgmail.sourceforge.net/</a>is what you need. <br /><br /> Regards, <br /><br/> Vishal Kashyap <br /><br /><br /> ---------------------------(end of broadcast)--------------------------- <br />TIP 3: if posting/reading through Usenet, please send an appropriate <br /> subscribe-nomail command to <a class="moz-txt-link-abbreviated"href="mailto:majordomo@postgresql.org">majordomo@postgresql.org</a> so that your <br /> message can get through to the mailing list cleanly <br /><br /></blockquote>
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 >