Re: Execute Shell script after insert

You can write the insert into command in a shellscript by using

#!/bin/bash

psql -c "INSERT INTO ...." <db_name> -U <username>

mkdir $1

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
>
>
>
> Thanks!!!