Обсуждение: Regarding calling shell script from postgres function

Поиск
Список
Период
Сортировка

Regarding calling shell script from postgres function

От
komala pelleti
Дата:
Hi,

I have requirement for calling a shell script from postgres function.

Please help me on this ?  

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

is there any otherway is there to do the same.


--
Regards
Komala P

Re: Regarding calling shell script from postgres function

От
Andreas Kretschmer
Дата:
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