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!!!
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general