Skip site navigation (1) Skip section navigation (2)

Re: Run external program from postgresql

From: Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>
To: PostgreSQL - mailing list <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Run external program from postgresql
Date: 2012-05-17 14:49:17
Message-ID: CAFcNs+oBgG8hBANs02fnsQ9vk2K1x3hZEV6a9eY-u557bPWwwg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
2012/5/17 francescoboccacci(at)libero(dot)it <francescoboccacci(at)libero(dot)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
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello

In response to

pgsql-admin by date

Next:From: francescoboccacci@libero.itDate: 2012-05-17 14:53:56
Subject: R: Re: Run external program from postgresql
Previous:From: francescoboccacci@libero.itDate: 2012-05-17 14:39:41
Subject: Run external program from postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group