Re: select from different database - Mailing list pgsql-general

From Shaun Thomas
Subject Re: select from different database
Date
Msg-id Pine.LNX.4.33L2.0108311140460.1999-100000@hamster.lee.net
Whole thread Raw
In response to select from different database  ("Jacob Vennervald Madsen" <jvm@gopinocchio.com>)
List pgsql-general
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              |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+



pgsql-general by date:

Previous
From: Giuseppe Tanzilli - CSF
Date:
Subject: Re: Apache authentication
Next
From: Shaun Thomas
Date:
Subject: Re: Regarding Vacuumdb