Skip site navigation (1) Skip section navigation (2)

Re: postgre linkage with non-postgre db

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 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-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

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-07-12 17:46:56
Subject: Re: postgre linkage with non-postgre db
Previous:From: Petronenko D.S.Date: 2006-07-12 16:39:05
Subject: postgre linkage with non-postgre db

pgsql-advocacy by date

Next:From: Joshua D. DrakeDate: 2006-07-12 17:46:29
Subject: Re: 10 Years And Counting
Previous:From: eleinDate: 2006-07-12 16:39:08
Subject: Re: 10 Years And Counting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group