two databases
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
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)