Re: postgre linkage with non-postgre db - Mailing list pgsql-novice

From
Subject Re: postgre linkage with non-postgre db
Date
Msg-id 20060712180722.33104.qmail@web33301.mail.mud.yahoo.com
Whole thread Raw
In response to postgre linkage with non-postgre db  ("Petronenko D.S." <petronenko@gmail.com>)
List pgsql-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

pgsql-novice by date:

Previous
From: "Petronenko D.S."
Date:
Subject: postgre linkage with non-postgre db
Next
From:
Date:
Subject: Re: Installer errors on WinXP SP2