From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | Chris Boget <chris(at)wild(dot)net> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: SELECT across multiple db |
Date: | 2003-05-20 12:49:26 |
Message-ID: | 1053434965.8734.17.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am Die, 2003-05-20 um 14.38 schrieb Chris Boget:
> > It's not exactly what I was looking for, because I wanted to do 1 query
> > across many databases and the results put together and sorted etc.
> > But with the keyword 'dblink' and google I found out that what I really
> > wanted is: SCHEMA :)
>
> Could you elaborate on the above? How does schema help you with
> doing queries across different databases?
Not really between multiple databases, but in my case, all the dbs
reside on the same host and thatway I can just create 1 db for all of
them and put the former dbs as schemas in this 1 db.
>From there you can REFERENCE, JOIN, etc. across these 'multiple dbs'.
If you'd like an example I can mail it to you.
If you cant put your dbs together (e.g. different hosts) you probably
should look into contrib/dblink as Joe stated.
cu
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de
From | Date | Subject | |
---|---|---|---|
Next Message | Dani Oderbolz | 2003-05-20 13:18:19 | Support for Synonyms? |
Previous Message | Thilo Hille | 2003-05-20 10:34:06 | table corruption |