Home > mailing lists

Select from different database - Mailing list pgsql-general

From	Jacob Vennervald Madsen
Subject	Select from different database
Date	August 29, 2001 07:19:08
Msg-id	19514C7E64E4FA4FBEEC9BA3CB3376FD17B67C@gopinocchio-sbs.gopinocchio.local Whole thread Raw
Responses	Re: Select from different database (Peter Eisentraut <peter_e@gmx.net>)
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:

From: Martijn van Oosterhout
Date: 29 August 2001, 05:55:19
Subject: Question about plan

From: "David M. Richter"
Date: 29 August 2001, 07:19:09
Subject: Compaq iPAQ and Postgresql

Select from different database - Mailing list pgsql-general

Previous

Next