I have created a DB1 with several tables. Now i need to create another DB2 with a linked table
from DB1. So if there is a table_X in DB1, is there a way to import that table_X into DB2 so that
any changes made to table_X in DB1 will also apply to DB2?
table_X has references to other tables in DB1 as well...will these references be maintained if
table_X is imported to DB2?
Any help is appreciated.
maybe dblink will do what you want:
http://pgfoundry.org/projects/snapshot/
Regards,
Richard Broersma Jr.