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
Import Notes
Resolved by subject fallback
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