>Can anyone give me an example of postgresql function that will execute a
>shell script?
>I will call the function from a postgresql trigger.
You need to create an untrusted language which I never did until now.
For example, plpgsql functions are trusted, i.e. they cannot access the
file system.
I would be interested in knowing how to do it.
Maybe it is possible with plperl or pltcl.
Best regards,
Jean-Michel POURE