Postgres Pro
Downloads
Home   >   mailing lists

Re: Linking Tables from 2 databases - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Linking Tables from 2 databases
Date
Msg-id 20060719191057.25835.qmail@web31804.mail.mud.yahoo.com
Whole thread Raw
In response to Linking Tables from 2 databases  ("Pratik Shukla" <pratikshukla@hotmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Anastasios Hatzis
Date:
Subject: Re: Difference between function and procedure?
Next
From: Cornelia Boenigk
Date:
Subject: Re: Problem creating a function