Skip site navigation (1) Skip section navigation (2)

Re: function accessing other db

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Marcus Andree S(dot) Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: function accessing other db
Date: 2004-02-12 15:52:32
Message-ID: 20040212155232.GA23348@wolff.to (view raw or flat)
Thread:
Lists: pgsql-novice
On Thu, Feb 12, 2004 at 13:41:21 -0200,
  "Marcus Andree S. Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br> wrote:
> 
> This would work if both tables (tablea and tableb) resides on the
> same database. What to do if, say tablea lives on database 'db1' and
> tableb resides on another database, 'db2' ?

Then the dblink contrib package might be of help. I haven't used it,
so I don't know for sure that it will solve your problem.

In response to

Responses

pgsql-novice by date

Next:From: Marcus Andree S. MagalhaesDate: 2004-02-12 16:29:28
Subject: Re: function accessing other db
Previous:From: Marcus Andree S. MagalhaesDate: 2004-02-12 15:41:21
Subject: Re: function accessing other db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group