Communication Between 2 Databases

Question

I have 2 databases and want to implement triggers on table update of database1 to do do some updates on database2's tables.

Example:
db1 has a table 1t1
db2 has a table 2t1
on inserting a touple into 1t1 i want to insert corresponding touple into 2t1

As of now Im using postgresql, but I dont mind switching to other free databases.
How to achieve this?

Answer 1

I suggest to use database link to establish a connection between two remote DB.

Take a look to this page:

http://www.postgresql.org/docs/current/static/contrib-dblink-connect.html

There is also a good tutorial here:

http://www.postgresonline.com/journal/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html

bye, Andrea

Answer 2

If you could replace databases with schemas everything becomes easy. Possibility of such replacement depends on why you have chosen databases as organisational units.