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

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