Re: Accessing tables from different databases

From: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
To: "K(dot) Deepa" <kdeepa(at)midascomm(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Accessing tables from different databases
Date: 2003-09-24 13:56:14
Message-ID: 20030924135614.GE306@bal740r0.mecon.gov.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Look at contrib/dblink.

Regards.

Fernando.
En un mensaje anterior, K. Deepa escribió:
> Hi all,
> I want to access a table-1 of database-1 from
> database-2. Is it possible in pgsql. If so,
> is it possible to define a foreign key constraint
> for a column in table-2 in database-2 which
> references to a column in table-1 in database-1.
> TIA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-09-24 13:56:52 Re: Accessing tables from different databases
Previous Message K. Deepa 2003-09-24 13:49:15 Accessing tables from different databases