Linking Tables from 2 databases

Pratik Shukla · *nix forums beginner Joined: 19 Jul 2006 Posts: 1

<html><div style='background-color:'><DIV class=RTE>Hello,</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>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?</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>table_X has references to other tables in DB1 as well...will these references be maintained if table_X is imported to DB2?</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Any help is appreciated.</DIV></div></html>

Richard Broersma Jr · *nix forums beginner Joined: 13 Mar 2006 Posts: 44

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

Merlin Moncure · *nix forums addict Joined: 19 Oct 2005 Posts: 87

On 7/19/06, Pratik Shukla <pratikshukla@hotmail.com> wrote:

Google