Michael Glaesemann <grzm(at)seespotcode(dot)net> writes:
> On Jul 30, 2009, at 9:09 , Radek Novotn wrote:
>> Is there possible to create pg trigger that runs shell script?
> Yes. You can use an untrusted language such as pl/perlu to run system
> commands.
The fact that you can do it doesn't make it a good idea ...
If you do this, you'll need to consider what happens if the database
transaction rolls back after calling your trigger. The effects in the
filesystem are still there, but the effects in the database aren't.
regards, tom lane