DBI-Link (http://pgfoundry.org/projects/dbi-link/) is probably your best bet. There's been some talk of expanding dblink, but nothing's happened on that yet. On Thu, Sep 08, 2005 at 10:37:23AM +0900, chandrasekare@xxxxxxxxxxx wrote: > Hi, > I am new to pgsql. > At present i ma having Oracle database and using pgsql for my new application. > I would like to access data exists in Oracle database from new pgsql database. > > Is there a way to link Oracle database from pgsql? > If not, is there any other ways to achieve it? > > Regards, > Chandra. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
