Postgres Pro
Downloads
Home   >   mailing lists

select from different database - Mailing list pgsql-general

From Jacob Vennervald Madsen
Subject select from different database
Date
Msg-id 9mgbs9$jq4$1@news.tht.net
Whole thread Raw
Responses Re: select from different database  (Shaun Thomas <sthomas@townnews.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Lee Crampton"
Date:
Subject: urgently wanted - plpgsql.so for pg 6.4.2
Next
From: "uncleleo"
Date:
Subject: !! Newbie question!!!! connecting to multiple databases