Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products?
Дата
Msg-id 4346245C.2040107@archonet.com
обсуждение исходный текст
Ответ на RULES on SELECT with JDBC/perlDBI from other RDBMS products?  ("Bath, David" <dave.bath@unix.net>)
Список pgsql-sql
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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Premsun Choltanwanich"
Дата:
Сообщение: How to delete Large Object from Database?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: How to delete Large Object from Database?