Re: How to execute external script from a TRIGGER or FUNCTION ? - Mailing list pgsql-general

From Andy Colson
Subject Re: How to execute external script from a TRIGGER or FUNCTION ?
Date
Msg-id 4A74E5D6.8080508@squeakycode.net
Whole thread Raw
In response to Re: How to execute external script from a TRIGGER or FUNCTION ?  (Denis BUCHER <dbucherml@hsolutions.ch>)
Responses Re: How to execute external script from a TRIGGER or FUNCTION ?  (Denis BUCHER <dbucherml@hsolutions.ch>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Janet Jacobsen
Date:
Subject: questions on (parallel) COPY and when to REINDEX
Next
From: Jun Yang
Date:
Subject: Can I add a super table to existing tables?