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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend