Re: select from different database

From: Shaun Thomas <sthomas(at)townnews(dot)com>
To: Jacob Vennervald Madsen <jvm(at)gopinocchio(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: select from different database
Date: 2001-08-31 16:44:07
Message-ID: Pine.LNX.4.33L2.0108311140460.1999-100000@hamster.lee.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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 |
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mikheev, Vadim 2001-08-31 16:45:49 Re: getting the oid for a new tuple in a BEFORE trigger
Previous Message Shaun Thomas 2001-08-31 16:39:49 Re: Too many open files in system FATAL2