Re: Access Two Databases - Mailing list pgsql-general

From Josh Jore
Subject Re: Access Two Databases
Date
Msg-id Pine.BSO.4.44.0207222229160.23685-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Access Two Databases  ("Dean Grubb" <dean@atrium-online.com.au>)
List pgsql-general
On Tue, 23 Jul 2002, Dean Grubb wrote:

> Is it possible using pl/pgSQL functions to grab data from another database
> or even another database on a different host.

This is where your external-to-PostgreSQL language comes in handy. Open a
second connection to the database, do whatever you are going to do and
mash the results together outside of PostgreSQL. If for some reason you
think the data is related then perhaps you've erred by having more than
one database.

Joshua b. Jore ; http://www.greentechnologist.org


pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Linux max on shared buffers?
Next
From: "Jim Morcombe"
Date:
Subject: Re: Can't link to libpq