Re: Regarding calling shell script from postgres function

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-sql(at)lists(dot)postgresql(dot)org,komala pelleti <p(dot)komala(at)gmail(dot)com>
Subject: Re: Regarding calling shell script from postgres function
Date: 2018-07-27 06:51:17
Message-ID: 8FC5C50C-56C4-439A-AAC0-FD4EF4789D8E@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 27 July 2018 08:12:05 CEST, komala pelleti <p(dot)komala(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message komala pelleti 2018-07-27 09:41:47 Regarding vacuumdb
Previous Message komala pelleti 2018-07-27 06:12:05 Regarding calling shell script from postgres function