I'm a bit vague on what you mean. Are you saying you want to be able to
say to postgres...
INSERT INTO message(to,subject,body) VALUES ('fred@foo.com', 'Hello',
'How\'s it going');
and instead of storing a message into postgres, it will send a mail
message to fred?
Then you want to say...
SELECT to, subject, body FROM messages;
And have a list of mail messages be returned, not from postgres tables,
but from your UNIX mailbox?
Just want to be clear on what you are asking.
paulmoody wrote:
>
> Hi,
> My first post to this list ... pls point me to correct list if
> wrong. Now my question ...
> Can I reference a field in a record where the data contained in the
> field is a value returned or passed to an arbitrary executable. For
> example say the arbitrary executable was a mail program then writing to
> the field would send a message and reading from the field would retrieve
> a message. However for all intents and purposes there would be no
> difference perceived by the query orginator than if the message was
> merely stored or retrieved from that field. ( ie is there a 'CGI' type
> interface for postgresql like for webservers ? ).
> TIA and regards.
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com