Multiple DB join

From: Sumeet Ambre <sambre(at)indiana(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Multiple DB join
Date: 2006-08-14 21:26:10
Message-ID: 44E0EA72.2090505@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

I have a database which consists of 20 million records and I've split up
the db into 6-7 dbs. I have a base database which consists of
the ids with link all the databases. I'm performing search on this
single base table. After searching i get some ids which are ids in the other
databases which i split up. Now i need to retrieve those records. Is
there a way i can join tables from multiple databases as we can join
multiple tables
in a single database.

Thanks,
SA.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Shoaib Mir 2006-08-14 22:04:35 Re: Multiple DB join
Previous Message Andrew Sullivan 2006-08-14 14:34:10 Re: SQLMAP IBATIS insert values from web forms to a money type column