Re: How to execute external script from a TRIGGER or FUNCTION ?

[Denis BUCHER <dbucherml@xxxxxxxxxxxxx>]

Hello,

Denis BUCHER a écrit :
> I need to execute an external script from Postgresql, it could be in
> perl, in bash/shell, in whatever...
> 
> Any help would be appreciated ! I just need a very simple example if
> possible...
> 
> I already searched on the web but found nothing...

After hours of search, I searched just some more and I think I found the
solution, hope it can be useful to someone else :

CREATE LANGUAGE plperlu;

CREATE FUNCTION test_perl_external (integer) RETURNS boolean AS $$
   $filename = '/tmp/somefile';
	if (-e $filename) { return true; }
    return false;
$$ LANGUAGE plperlu;

SELECT test_perl_external(1);

Denis


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general