Thread: Execute external program

Execute external program

From
"Toff"
Date:
Hi,

I'm still thinking on the problem of transferring data to a 2nd database.
I've learnt some things but some are too complex....

Now I'm thinking of executing an external program (written in delphi) with a
(untrusted) Procedural Language on the event of a trigger.
Thus something like
"
CREATE FUNCTION transfer_to_db2 RETURNS TRIGGER $$
    execute(....../transfer_to_db2.exe);
$$ LANGUAGE ..........
"

Is this possible?
I know i can install a language in pg, but i prefer an extrenal program (so
i can connect it with pg and nobody else has to worry about pg).

Thanks,

Kristoff