Denis BUCHER wrote:
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
You want to run a script? The above would test to see if it exists, but not run it.
Use qx/cmd args/ or system('cmd args') to run it. (In perl anyway, I dunno if plperl supports it)
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
