Re: Multiple DB join
| От | Shoaib Mir |
|---|---|
| Тема | Re: Multiple DB join |
| Дата | |
| Msg-id | bf54be870608141504m428b3af1tf1706fb8ed537d7e@mail.gmail.com обсуждение исходный текст |
| Ответ на | Multiple DB join (Sumeet Ambre <sambre@indiana.edu>) |
| Список | pgsql-sql |
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)
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 по дате отправления: