From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | "Petronenko D(dot)S(dot)" <petronenko(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: postgre linkage with non-postgre db |
Date: | 2006-07-12 17:39:27 |
Message-ID: | 20060712173927.GA21331@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-novice |
On Wed, Jul 12, 2006 at 07:39:05PM +0300, Petronenko D.S. wrote:
> Can i get data in postgre from non-postgre db?
The name is PostgreSQL or Postgres, not postgre.
http://www.postgresql.org/docs/faqs.FAQ.html#item1.1
> For example, can i link mysql db over odbc connection to postgre
> database? So, i will be able to use queries in PG like select * from
> table1, where table1 is from mysql db.
If you have Perl installed then you can do this with dbi-link or
by writing your own PL/PerlU function that uses DBI. You could
create a view to hide the function call, although a limitation of
doing so is that WHERE restrictions would be applied after fetching
the entire result set, which would be inefficient if you want only
a few rows from a large table.
http://pgfoundry.org/projects/dbi-link/
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-07-12 17:46:29 | Re: 10 Years And Counting |
Previous Message | elein | 2006-07-12 16:39:08 | Re: 10 Years And Counting |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-07-12 17:46:56 | Re: postgre linkage with non-postgre db |
Previous Message | Petronenko D.S. | 2006-07-12 16:39:05 | postgre linkage with non-postgre db |