X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 548439F97C2
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 14 Aug 2006 18:56:41 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 00181-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 14 Aug 2006 18:56:30 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id C3A7D9FB282
	for <pgsql-sql@postgresql.org>; Mon, 14 Aug 2006 18:56:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from plounts.uits.indiana.edu (plounts.uits.indiana.edu
	[129.79.1.73])
	by svr4.postgresql.org (Postfix) with ESMTP id B16AB5AF034
	for <pgsql-sql@postgresql.org>; Mon, 14 Aug 2006 21:26:12 +0000 (GMT)
Received: from mail-relay.iu.edu (logchain.uits.indiana.edu [129.79.1.77])
	by plounts.uits.indiana.edu (8.13.6/8.12.10/IUPO) with ESMTP id
	k7ELQ9ni012830
	for <pgsql-sql@postgresql.org>; Mon, 14 Aug 2006 17:26:10 -0400 (EDT)
Received: from [129.79.36.131] (widit-win02.slis.indiana.edu [129.79.36.131])
	(authenticated bits=0)
	by mail-relay.iu.edu (8.13.6/8.12.10/IUPO) with ESMTP id k7ELQA2Q019552
	for <pgsql-sql@postgresql.org>; Mon, 14 Aug 2006 17:26:10 -0400 (EDT)
Message-ID: <44E0EA72.2090505@indiana.edu>
Date: Mon, 14 Aug 2006 17:26:10 -0400
From: Sumeet Ambre <sambre@indiana.edu>
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Multiple DB join
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.235 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200608/98
X-Sequence-Number: 26056

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.