Re: Accessing a database form another database

Bill Thoen wrote:
> I've got some GIS tables that I want to use across several projects and
> currently I've got each project in a separate database. So say I've got
> two databases, one for the Spacely Sprookets project and one for the
> Cogswell Cogs contract, but I want to access my WorldMap tables in my
> GIS database to make maps for both of these projects.  How do I
> reference a table that's in another database? Or should I organize my
> PostgreSQL data differently?

You can use dblink for this purpose:


http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html


--
Guy Rouillier