Re: Execute Shell script after insert - Mailing list pgsql-general

From Hannes Dorbath
Subject Re: Execute Shell script after insert
Date
Msg-id 490606A4.90508@theendofthetunnel.de
Whole thread Raw
In response to Execute Shell script after insert  ("Anderson dos Santos Donda" <andersondonda@gmail.com>)
Responses Re: Execute Shell script after insert  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Anderson dos Santos Donda wrote:
> Is there a way to execute a simple shell script in server after execute
> INSERT INTO ?
>
> Example?
>
> INSERT INTO clients (name) VALUES ('Donda');
>
> after it, execute shell : mkdir $1

You might find the following project useful:

http://plsh.projects.postgresql.org/

It adds sh as a procedural language to your PostgreSQL installation.
Please be aware that there are the same security concerns as with all
other untrusted procedural languages.


--
Best regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: "Anderson dos Santos Donda"
Date:
Subject: Execute Shell script after insert
Next
From: "Scott Marlowe"
Date:
Subject: Re: Execute Shell script after insert