Re: Execute Shell script after insert

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