I do something of that sort right now to support an email notification
service. Rather than use Procmail, I use scripts written in Perl which
accept a message, parse it up using the Mail::Internet and
Mail::Address modules, and then insert it into the database. Works
like a charm.
At 08:09 AM 10/26/98 , Dan Delaney wrote:
>Hi all.
> I'd like to set up a DB using postgreSQL to archive a
>mailing list. How would I go about getting all of the mail
>sent to the list to be automatically entered into the
>database when it is sent? I assume I would need to set up an
>email address for the list to send to, something like
>"archive@blahblah.org", but what would I need to do to get
>it into the database? Something in sendmail? Use procmail?
>Any ideas?
>
> --Dan
>
>-----------------------------------------------------------------------
> Daniel G. Delaney The Louisville Times Chorus
> Dionysos@Dionysia.org www.LouisvilleTimes.org
> www.Dionysia.org/~dionysos/ Dionysia Design
> ICQ Number: 8171285 www.Dionysia.com/design/
>-----------------------------------------------------------------------
> "Only two things are infinite: the universe and stupidity--
> and I'm not sure about the former."
> --Albert Einstein