Postgres Pro
Downloads
Home   >   mailing lists

Re: Multiple DB join - Mailing list pgsql-sql

From Shoaib Mir
Subject Re: Multiple DB join
Date
Msg-id bf54be870608141504m428b3af1tf1706fb8ed537d7e@mail.gmail.com
Whole thread Raw
In response to Multiple DB join  (Sumeet Ambre <sambre@indiana.edu>)
List pgsql-sql
Tree view
I think using the contrib module 'dblink' (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/) can help you here.

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 8/15/06, Sumeet Ambre < sambre@indiana.edu> wrote:
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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster




pgsql-sql by date:

Previous
From: Sumeet Ambre
Date:
Subject: Multiple DB join
Next
From: Kyle Bateman
Date:
Subject: Re: Using bitmap index scans-more efficient