Postgres Pro
Downloads
Home   >   mailing lists

Accessing a database form another database - Mailing list pgsql-general

From Bill Thoen
Subject Accessing a database form another database
Date
Msg-id 4A804F4A.50300@gisnet.com
Whole thread Raw
Responses Re: Accessing a database form another database
Re: Accessing a database form another database
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Juan Backson
Date:
Subject: PQstatus does not seem to work
Next
From: John R Pierce
Date:
Subject: Re: NOTICE: there is no transaction in progress