Thread: Querying multiple databases...
In Oracle, it is possible to use DB links to run a query across more than one database (ie. Select * from table_in_thisdb, table1@externaldb). Is there any way to perform something similar in Postgres?
Doug
See /contrib/dblink. --------------------------------------------------------------------------- Douglas Mayle wrote: > In Oracle, it is possible to use DB links to run a query across more than > one database (ie. Select * from table_in_thisdb, table1@externaldb). Is > there any way to perform something similar in Postgres? > > > > <http://dmayle.com/dotsig.gif> > > Doug > > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073