Write the trigger-function using an untrusted language like PL/TclU, PL/PerlU, or PL/PythonU. (Note the 'U' at the end...) You can call arbitrary commands within an untrusted language. With the regular trusted languages (such plpgsql, PL/Perl or the like) you can't call external programs.
Last edited by loquin; 07-30-09 at 17:18.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert