Re: functions, shell script - Mailing list pgsql-general

From Jean-Michel POURE
Subject Re: functions, shell script
Date
Msg-id 4.2.0.58.20011106085942.00a7cca0@pop.freesurf.fr
Whole thread Raw
In response to functions, shell script  ("Kenneth Skiles" <ka.skiles@verizon.net>)
List pgsql-general
>Can anyone give me an example of postgresql function that will execute a
>shell script?
>I will call the function from a postgresql trigger.

You need to create an untrusted language which I never did until now.
For example, plpgsql functions are trusted, i.e. they cannot access the
file system.

I would be interested in knowing how to do it.
Maybe it is possible with plperl or pltcl.

Best regards,
Jean-Michel POURE


pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: Referring a table in another database
Next
From: Jean-Michel POURE
Date:
Subject: Re: Use of Serial Datatype and Sequence Issue