Linking Tables from 2 databases

From: "Pratik Shukla" <pratikshukla(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Linking Tables from 2 databases
Date: 2006-07-19 17:54:07
Message-ID: BAY103-F32D4E8A63D5BB8AB36FF97D2600@phx.gbl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html><div style='background-color:'><DIV class=RTE>Hello,</DIV>
<DIV class=RTE>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>
<DIV class=RTE>Any help is appreciated.</DIV></div></html>

Attachment Content-Type Size
unknown_filename text/html 627 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2006-07-19 17:58:38 Re: Messages to pgsql-general list not being posted
Previous Message Merlin Moncure 2006-07-19 17:41:32 Re: Difference between function and procedure?