Re: Linking Tables from 2 databases

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Pratik Shukla <pratikshukla(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Linking Tables from 2 databases
Date: 2006-07-19 19:10:57
Message-ID: 20060719191057.25835.qmail@web31804.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Cornelia Boenigk 2006-07-19 19:16:14 Re: Problem creating a function
Previous Message Anastasios Hatzis 2006-07-19 18:42:15 Re: Difference between function and procedure?