On 16 November 2010 20:09, Hu, William <HuW@xxxxxxxxxx> wrote: > Hi, I have a need to select some data in a Oracle database from a Postgresql > table. I know how to do this among Oracle instances, eg. Select * from > table@another_instance. > > > > Are there similar approach without replicate the database tables? > > > > Thanks in advance. Yes. Look at dbi-link. -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general