What i need is, when ever a NEW record is inserted in 'MyDb1' , i want fire a Trigger or Rule to insert the Same Record to MyDb2 database.
Anybody Got Idea how to do this?
See the dblink documentation for dblink_exec(), and see the Postgres documentation for how to create triggers:
http://www.postgresql.org/docs/current/static/triggers.html
You'll probably want to create the trigger function using PL/pgSQL:
http://www.postgresql.org/docs/current/static/plpgsql.html
Joe
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
