| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | dave(dot)bath(at)unix(dot)net |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products? |
| Date: | 2005-10-07 07:31:40 |
| Message-ID: | 4346245C.2040107@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2005-10-07 10:23:53 | Re: RULES on SELECT with JDBC/perlDBI from other RDBMS |
| Previous Message | Richard Huxton | 2005-10-07 07:30:05 | Re: How to delete Large Object from Database? |