Execute external program - Mailing list pgsql-novice

From Toff
Subject Execute external program
Date
Msg-id TmTTe.188702$wk1.10400827@phobos.telenet-ops.be
Whole thread Raw
List pgsql-novice
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





pgsql-novice by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [ADMIN] Please help - libpq API
Next
From: "Renaldo Hylton"
Date:
Subject: Transfer to MSSQL