Thread: select from different database

Hi All

Is it possible to fetch data from another database than the current?
E.g. like in Oracle I can select data from 2 different DB's like this:

select * from db1.table1 as tbl1, db2.table2 as tbl2 where tbl1.id1 =
tbl2.id2;

Jacob

On Tue, 28 Aug 2001, Jacob Vennervald Madsen wrote:

> Is it possible to fetch data from another database than the current?
> E.g. like in Oracle I can select data from 2 different DB's like this:

This has already been discussed.  Postgres doesn't have this ability.

Emulating Oracle's concept of schemas is on the list hoever,
which *will* allow multiple-DB interactions.  You'll just have to
wait for that one. ^_^

--
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
| Shaun M. Thomas                INN Database Programmer              |
| Phone: (309) 743-0812          Fax  : (309) 743-0830                |
| Email: sthomas@townnews.com    AIM  : trifthen                      |
| Web  : hamster.lee.net                                              |
|                                                                     |
|     "Most of our lives are about proving something, either to       |
|      ourselves or to someone else."                                 |
|                                           -- Anonymous              |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+