Re: One SQL to access two databases. - Mailing list pgsql-general

From scott.marlowe
Subject Re: One SQL to access two databases.
Date
Msg-id Pine.LNX.4.33.0212031000190.32558-100000@css120.ihs.com
Whole thread Raw
In response to Re: One SQL to access two databases.  (pilsl@goldfisch.at)
List pgsql-general
On Fri, 29 Nov 2002 pilsl@goldfisch.at wrote:

> > >
> > > Does anybody know if postgres support a SQL statement that handles two
> > > diferent databases (in the same server)?
> >
> > Have a look at the contrib/dblink directory in the standard postgresql
> > distro.
> >
>
> Didnt find such a directory (or a similar one) in my 7.1.3-distri and
> this would be very helpful to save db-handles in persistent programs.

Yeah, it sounds like you're running an older version of Postgresql.  Good
news, 7.3 is out.  I'd suggest upgrading to it and then you should have
the contrib/dblink directory.


pgsql-general by date:

Previous
From: Jeff Boes
Date:
Subject: pg_relcheck gone from 7.3?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] 7.3 -> pg_atoi: zero-length string