Thread: 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

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
>
>