Thread: Mail to DB.

Mail to DB.

From
"Jason C. Leach"
Date:
hi,

I've read that a few of you are putting email into a postgres DB.  I'd
be interested in doing something similar.  Would any of you care to
share the secret that allows sendmail to deposit the email to a db, or
how you get it from /var/spool/mail/mailbox into the table when new mail
arrives?

Thanks,
Jason

--
.............
......... Jason C. Leach
...... University College of the Cariboo
... jcl@mail.ocis.net.
.. http://www.ocis.net/~jcl
.


Debain!Linux!




Re: [GENERAL] Mail to DB.

From
Howie
Date:
On Sat, 27 Nov 1999, Jason C. Leach wrote:

> hi,
>
> I've read that a few of you are putting email into a postgres DB.  I'd
> be interested in doing something similar.  Would any of you care to
> share the secret that allows sendmail to deposit the email to a db, or
> how you get it from /var/spool/mail/mailbox into the table when new mail
> arrives?

a friend and i were just talking about this... you could use procmail to
spawn a program that inserts the data into pgsql.  youd most likely want
to use LO's for the email body, storing To:, From:, Cc:, and Subject: in a
table ( for queries ).

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
"Tell a man that there are 400 billion stars and he'll believe you.
 Tell him a bench has wet paint and he has to touch it."


RE: [GENERAL] Mail to DB.

From
"Darvin Zuch"
Date:
I understand Oracle 8i does something like this (also acting as an FTP
backend).
You might want to scower their site for good ideas

Darvin Zuch

-----Original Message-----
From: owner-pgsql-general@postgreSQL.org
[mailto:owner-pgsql-general@postgreSQL.org]On Behalf Of Howie
Sent: Sunday, November 28, 1999 3:39 PM
To: Jason C. Leach
Cc: pgsql-list
Subject: Re: [GENERAL] Mail to DB.


On Sat, 27 Nov 1999, Jason C. Leach wrote:

> hi,
>
> I've read that a few of you are putting email into a postgres DB.  I'd
> be interested in doing something similar.  Would any of you care to
> share the secret that allows sendmail to deposit the email to a db, or
> how you get it from /var/spool/mail/mailbox into the table when new mail
> arrives?

a friend and i were just talking about this... you could use procmail to
spawn a program that inserts the data into pgsql.  youd most likely want
to use LO's for the email body, storing To:, From:, Cc:, and Subject: in a
table ( for queries ).

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
"Tell a man that there are 400 billion stars and he'll believe you.
 Tell him a bench has wet paint and he has to touch it."


************