Thread: is possible to read oracle tables from PostgresSQL
I need to know if is possible to read oracle tables from PostgresSQL (and vice versa). Can someone give me some help? Thanks a lot
Wel, If you use Plperl I supposed or perl!! >From: "Marco" <marko78@libero.it> >To: pgsql-general@postgresql.org >Subject: [GENERAL] is possible to read oracle tables from PostgresSQL >Date: Wed, 15 Oct 2003 19:10:42 GMT > >I need to know if is possible to read oracle tables from PostgresSQL (and >vice versa). >Can someone give me some help? > > > >Thanks a lot > > > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster _________________________________________________________________ ¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
Use ODBC or OLEDB drivers to do this. Some ODBC drivers can transparently perform heterogeneous joins across multiple database systems. Even for those that cannot accomplish this, you could use some tool like SQL*Server with Linked servers or even Microsoft Access to perform the joins. > -----Original Message----- > From: Marco [mailto:marko78@libero.it] > Sent: Wednesday, October 15, 2003 12:11 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] is possible to read oracle tables from PostgresSQL > > > I need to know if is possible to read oracle tables from > PostgresSQL (and vice versa). Can someone give me some help? > > > > Thanks a lot > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >