Re: [SQL] Queries across multiple database

2004-06-30 Thread Gregory S. Williamson
Although postgres itself doesn't seem to have a thing such as Informix' "synonym" which allows more-or-less transparent access to a table in a remote database, there is a utility in contrib directory of the postgres source called dblink, which allows access to different instance of postgres by o

Re: [SQL] Queries across multiple database

2004-06-30 Thread Rod Taylor
On Wed, 2004-06-30 at 18:54, Garth Thompson wrote: > I am in the process of migrating the databases for an application from mysql > to postgres. The application is uses several different databases. From > what I have read, postgres still does not support queries across multiple > databases. If t