From: Oliver Elphick <olly@lfix.co.uk>
To: Devrim GUNDUZ <devrim@gunduz.org>
Cc: Jodi Kanter <jkanter@virginia.edu>
Cc: Postgres Admin List <pgsql-admin@postgresql.org>
Subject: Re: cross databases?
Date: Thu, 08 Jul 2004 17:00:49 +0100
Message-ID: <1089302449.29038.10.camel@braydb> (raw)
In-Reply-To: <Pine.LNX.4.44.0407081833390.15836-100000@emo.org.tr>
References: <Pine.LNX.4.44.0407081833390.15836-100000@emo.org.tr>
On Thu, 2004-07-08 at 16:34, Devrim GUNDUZ wrote:
> On Thu, 8 Jul 2004, Jodi Kanter wrote:
>
> > I am working with someone who uses MySQL and says that he has two
> > separate databases in which he can query across. I am curious if that is
> > something that can be done in postgres?
>
> Yes, it's possible with PostgreSQL.
>
> See contrib/dblink.
But a more convenient alternative is to use schemas, which MySQL does
not (I think) support.
Oliver Elphick
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: olly@lfix.co.uk, devrim@gunduz.org, jkanter@virginia.edu
Subject: Re: cross databases?
In-Reply-To: <1089302449.29038.10.camel@braydb>
References: <Pine.LNX.4.44.0407081833390.15836-100000@emo.org.tr> <1089302449.29038.10.camel@braydb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox