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.tew@budgens.co.uk>
To: <pgsql-novice@postgresql.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
>
>