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

From: nick(dot)tew(at)budgens(dot)co(dot)uk (Nick Tew)
To: pgsql-novice(at)postgresql(dot)org
Subject: Emailing a list of users when a record is entered in the database.
Date: 2004-01-27 12:14:15
Message-ID: 1aba8199.0401270414.4b83485b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Marcin Gil 2004-01-27 13:21:27 Re: db security; user identification
Previous Message Martin Atukunda 2004-01-27 11:50:50 Re: db security; user identification