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

From Joe Conway
Subject Re: One SQL to access two databases.
Date
Msg-id 3DE7A05F.8010202@joeconway.com
Whole thread Raw
In response to One SQL to access two databases.  (Diogo Biazus <diogo@ikono.com.br>)
List pgsql-general
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.

dblink was first released with PostgreSQL 7.2. But as of yesterday, a "new and
improved" PostgreSQL 7.3 was released with a much improved dblink. If you can,
upgrade to 7.3.

Joe


pgsql-general by date:

Previous
From: "Jan-Philipp 'Thefly' Reining"
Date:
Subject: The old "not using index" question
Next
From: pginfo
Date:
Subject: Re: RPMS for 7.3