From: Richard Huxton <dev@archonet.com>
To: dave.bath@unix.net
Cc: pgsql-sql@postgresql.org
Subject: Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products?
Date: Fri, 07 Oct 2005 08:31:40 +0100
Message-ID: <4346245C.2040107@archonet.com> (raw)
In-Reply-To: <200510071107.38564.dave.bath@unix.net>
References: <200510071107.38564.dave.bath@unix.net>
Bath, David wrote:
> Folks,
>
> I'm looking at using pg to be the main platform for integrating info
> from other RDBMS products (particularly Oracle) as pg seems to be
> the most flexible RDBMS around.
>
> Disregarding writing to foreign products, query-plan efficiencies,
> or differences of SQL dialect, I'd like to have a way of setting
> up a fairly-transparent SELECT within pg that pulls rows from the
> other product. I wonder if anyone has attempted something like
> this, and can recommend (or even deprecate) an approach, and perhaps
> point to a code template.
Are you familiar with the dblink() module in the contrib/ directory of
the source distribution?
--
Richard Huxton
Archonet Ltd
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, dave.bath@unix.net
Subject: Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products?
In-Reply-To: <4346245C.2040107@archonet.com>
* 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