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

Is it something that will come in later versions?

Jacob

-----Original Message-----
From: Peter Eisentraut [mailto:peter_e@gmx.net]
Sent: 29. august 2001 13:42
To: Jacob Vennervald Madsen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Select from different database


Jacob Vennervald Madsen writes:

> Is it possible to fetch data from another database than the current?

No.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Jacob Vennervald Madsen writes:

> Is it possible to fetch data from another database than the current?

No.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

> Jacob Vennervald Madsen writes:
>
> > Is it possible to fetch data from another database than the current?
>
> No.

New FAQ item:

    <H4><A href="#4.25">4.25</A>) How do I perform queries
    using multiple databases?<H4>

    <P>There is no way to query any database except the current one.
    Because PostgreSQL loads database-specific system catalogs, it is
    uncertain how a cross-database query should even behave.</P>

    <P>Of course, a client can make simultaneous connections to
    different databases and merge the information that way.</P>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026