Re: One SQL to access two databases.

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: <pilsl(at)goldfisch(dot)at>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: One SQL to access two databases.
Date: 2002-12-03 17:01:17
Message-ID: Pine.LNX.4.33.0212031000190.32558-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Fri, 29 Nov 2002 pilsl(at)goldfisch(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Henner Zeller 2002-12-03 17:07:52 Re: [GENERAL] 7.3 -> pg_atoi: zero-length string
Previous Message Jeff Boes 2002-12-03 16:56:53 pg_relcheck gone from 7.3?

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Naeslund(f) 2002-12-03 17:03:16 Re: Backend crash with tsearch
Previous Message scott.marlowe 2002-12-03 16:59:23 Re: How to compile postgres source code in VC++