Re: Accessing tables from different databases

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
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:52
Message-ID: 3F71A2A4.8030502@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

K. Deepa wrote:
> Hi all,
> I want to access a table-1 of database-1 from
> database-2. Is it possible in pgsql. If so,

Yes. You need to use dblink contrib module for that.

> 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.

I am afraid that's not possible.

Shridhar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bartlett 2003-09-24 14:07:18 Re: career in SQL/Database administration
Previous Message Fernando Schapachnik 2003-09-24 13:56:14 Re: Accessing tables from different databases