Postgres Pro
Downloads
Home   >   mailing lists

Thread: Run external program from postgresql

Run external program from postgresql

From
"francescoboccacci@libero.it"
Date:
Hi all,
i have a question. I'd like to create a trigger function that "call" and
external application (es . C:\myprogram.exe) when a new row will be insert in a
table.
Is it possible? How can do that?

Thanks

Francesco

Re: Run external program from postgresql

From
Fabrízio de Royes Mello
Date:

2012/5/17 francescoboccacci@libero.it <francescoboccacci@libero.it>
Hi all,
i have a question. I'd like to create a trigger function that "call" and
external application (es . C:\myprogram.exe) when a new row will be insert in a
table.
Is it possible? How can do that?


Yes, it is. But you'll have to use an untrusted language like C, pl/python, pl/perl, etc.

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com