Re: postgre linkage with non-postgre db

> 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