On Mon, Aug 10, 2009 at 10:48:10AM -0600, 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? That last is much easier. Create a schema each for Spacely and Cogswell, then one for WorldMap. http://www.postgresql.org/docs/current/static/sql-createschema.html Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
