Accessing a database form another database

From: Bill Thoen <bthoen(at)gisnet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Accessing a database form another database
Date: 2009-08-10 16:48:10
Message-ID: 4A804F4A.50300@gisnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks,
- Bill Thoen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-08-10 16:51:32 Re: NOTICE: there is no transaction in progress
Previous Message Juan Backson 2009-08-10 16:41:47 PQstatus does not seem to work