Re: Access Two Databases - Mailing list pgsql-general

From Joe Conway
Subject Re: Access Two Databases
Date
Msg-id 3D3CD49C.1040401@joeconway.com
Whole thread Raw
In response to Re: Access Two Databases  (Darren Ferguson <darren@crystalballinc.com>)
Responses Re: Access Two Databases
List pgsql-general
Darren Ferguson wrote:
> Not that i am aware of
>
> On Tue, 23 Jul 2002, Dean Grubb wrote:
>>Hi,
>>
>>Is it possible using pl/pgSQL functions to grab data from another database
>>or even another database on a different host.

You can with contrib/dblink.

In 7.2, it is a bit (well, maybe more than a bit) awkward, but it works.
I hope to have some substantial improvements in usability for the
upcoming 7.3 release making use of the new table functions feature.

Joe


pgsql-general by date:

Previous
From: "Jim Morcombe"
Date:
Subject: Re: Can't link to libpq
Next
From: Joe Conway
Date:
Subject: Re: Cross-Tab queries in postgres?