On Mon, Oct 27, 2008 at 03:09:31PM -0300, Anderson dos Santos Donda wrote: > Is there a way to execute a simple shell script in server after execute > INSERT INTO ? Yes; as other people have said most of the procedural languages allow you to run code outside PG. You'd just need to hook this procedure up to a trigger inside postgres that ran when data was inserted. As a rule, though, I'd tend not to do this. The rationale being, when something goes wrong (as code inevitably does) the database will continue doing things automatically for you (like touching the filesystem) when you're fighting against it trying to fix things. I'd be more tempted to write a stored procedure that inserted something into a table and did the fiddling with the outside world. That way you can still write normal INSERT statements to fix up the database and not worry about your triggers trying to be helpful. I'd expect to stop normal users from being able to INSERT data into the table, thus forcing them (or, more accurately, the code running on their behalf) to use the stored procedure. Sam -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
