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

Re: postgre linkage with non-postgre db

From: <operationsengineer1(at)yahoo(dot)com>
To: "Petronenko D(dot)S(dot)" <petronenko(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Cc: "Petronenko D(dot)S(dot)" <petronenko(at)gmail(dot)com>
Subject: Re: postgre linkage with non-postgre db
Date: 2006-07-12 18:07:22
Message-ID: 20060712180722.33104.qmail@web33301.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-novice
> Hello,
> 
> Can i get data in postgre from non-postgre db?
> 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.
> 
> Thanks.
> 

isn't this the job of the application?

i use php's adodb's db abstraction layer and this kind
of think s/b trivial.

you need the connection information for both
databases, of course.

you just make a call to a db and pass all the
connection information.  of course, the syntax of the
call and the connection information will be different
(some could be the same, like password, but you know
what i mean).

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

In response to

pgsql-novice by date

Next:From: Sean DavisDate: 2006-07-12 19:16:21
Subject: Re: postgre linkage with non-postgre db
Previous:From: operationsengineer1Date: 2006-07-12 18:02:15
Subject: Re: Installer errors on WinXP SP2

pgsql-advocacy by date

Next:From: Sean DavisDate: 2006-07-12 19:16:21
Subject: Re: postgre linkage with non-postgre db
Previous:From: Richard Broersma JrDate: 2006-07-12 17:46:56
Subject: Re: postgre linkage with non-postgre db

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