Re: [GENERAL] Select from different database

2001-09-03 Thread Bruce Momjian
> Jacob Vennervald Madsen writes: > > > Is it possible to fetch data from another database than the current? > > No. New FAQ item: 4.25) How do I perform queries using multiple databases? There is no way to query any database except the current one. Because PostgreSQL loads da

[GENERAL] Select from different database

2001-08-29 Thread Jacob Vennervald Madsen
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 ---(end of broadcast)---