Thread: two databases

two databases

From
"mourad_dhambri"
Date:
I am creating a query in a database db1 that retrieves data from another database db2.
How can I do this in PostGres?
In Oracle I can write "select * from db2.table1.field1".
thanks.

------------------------------------------

Faites un voeu et puis Voila ! www.voila.fr


Re: two databases

From
"Shridhar Daithankar"
Date:
On 26 Sep 2002 at 12:19, mourad_dhambri wrote:

> I am creating a query in a database db1 that retrieves data from another database db2.
> How can I do this in PostGres?
> In Oracle I can write "select * from db2.table1.field1".

You can use dblink function in contrib that allows you to create database links
just like oracle..(OK may not be comparable but still..)

HTH

Bye
 Shridhar

--
"How should I know if it works?  That's what beta testers are for.  I onlycoded
it."(Attributed to Linus Torvalds, somewhere in a posting)