Re: Regarding calling shell script from postgres function - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: Regarding calling shell script from postgres function
Date
Msg-id 8FC5C50C-56C4-439A-AAC0-FD4EF4789D8E@a-kretschmer.de
Whole thread Raw
In response to Regarding calling shell script from postgres function  (komala pelleti <p.komala@gmail.com>)
List pgsql-sql
On 27 July 2018 08:12:05 CEST, komala pelleti <p.komala@gmail.com> wrote:
>Hi,
>
>I have requirement for calling a shell script from postgres function.
>
>Please help me on this ?


You can use an untrusted language like pl/perlU or plsh, but only as superuser.


>
>In our postgres db plsh,plperl extension are not enabled and control
>files
>not available.


Why?

>
>is there any otherway is there to do the same.

Afaik no.



Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company


pgsql-sql by date:

Previous
From: komala pelleti
Date:
Subject: Regarding calling shell script from postgres function
Next
From: komala pelleti
Date:
Subject: Regarding vacuumdb