Postgres Pro
Downloads
Home   >   mailing lists

Re: Accessing tables from different databases - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: Accessing tables from different databases
Date
Msg-id 3F71A2A4.8030502@persistent.co.in
Whole thread Raw
In response to Accessing tables from different databases  ("K. Deepa" <kdeepa@midascomm.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "K. Deepa"
Date:
Subject: Accessing tables from different databases
Next
From: "Esger Abbink"
Date:
Subject: data directory growing huge