Re: Execute Shell script after insert

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Anderson dos Santos Donda <andersondonda(at)gmail(dot)com>
Subject: Re: Execute Shell script after insert
Date: 2008-10-27 18:21:24
Message-ID: 490606A4.90508@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-10-27 18:35:45 Re: Execute Shell script after insert
Previous Message Anderson dos Santos Donda 2008-10-27 18:09:31 Execute Shell script after insert