Re: select from different database

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(at)townnews(dot)com AIM : trifthen |
| Web : hamster.lee.net |
| |
| "Most of our lives are about proving something, either to |
| ourselves or to someone else." |
| -- Anonymous |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+