| From: | Grégory Luguet <gregory(dot)luguet(at)evidian(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | [trigger] is it possible to launch a shell script? |
| Date: | 2002-10-10 08:51:21 |
| Message-ID: | 00a001c2703a$34bcfcd0$13a2b681@panpan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello all,
I have to synchronize the content of 2 databases, each one being used by an
application from our Information System ; unfortunately these apps require a
specific DBMS : one needs MySQL and the other Postgresql.
Now I want the mysql database to be updated with the data from Postgresql
when this one is updated itself.
I heard about triggers, but I did not find any way to activate something
else than an SQL procedure with Postgresql ; with Oracle I know that I can
launch nearly whatever I want (including standalone sowtware) and I can
easily write a shell script which would call the mysql & insert the data,
BUT is it possible at all?
Thank you in advance for your answers, remarks and suggestions.
Faithfully yours,
Grégory Luguet
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludwig Lim | 2002-10-10 10:18:34 | Re: [trigger] is it possible to launch a shell script? |
| Previous Message | Devinder K Rajput | 2002-10-09 21:38:51 | Re: Number Sequence Query |