two databases

From: mourad_dhambri <mourad_dhambri(at)voila(dot)fr>
To: pgsql-general <pgsql-general(at)PostgreSQL(dot)org>
Subject: two databases
Date: 2002-09-26 10:19:49
Message-ID: H31JD1$FE0ECFCB5C8895A023D1F0BF8F5FDF9D@voila.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-09-26 10:23:50 Re: two databases
Previous Message Peter Alberer 2002-09-26 10:15:00 Re: Adding "on delete cascade" after table creation ?