Re: Emailing a list of users when a record is entered in the database.

I installed a great function called pgmail. Then I wrote a trigger that
sends email when certain conditions are met.
see: http://sourceforge.net/projects/pgmail/

Derrick

----- Original Message -----
From: "Nick Tew" <nick(dot)tew(at)budgens(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, January 27, 2004 5:14 AM
Subject: [NOVICE] Emailing a list of users when a record is entered in the
database.

> Hi,
>
> I need to develop my database so when a record is entered through a
> browser, it will automatically email a list of interested parties. I
> am ok at designing the tables so the relevant personid's have the
> email address and their interested subjects. But can anybody help on
> how to email the parties when the data is passed.
>
> The only knowledge i have on this is the command
>
> "cat {filename} | mail {emailadd} -s {subject}
>
> Thanks in advance for any help
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>