Re: Multi Database queries - Mailing list pgsql-novice

From Joe Conway
Subject Re: Multi Database queries
Date
Msg-id 4150F621.6050502@joeconway.com
Whole thread Raw
In response to Multi Database queries  (Jonathon Batson <jonathon@octahedron.com.au>)
Responses Re: Multi Database queries
List pgsql-novice
Jonathon Batson wrote:
> I am looking into setting up a multi-database system with Postgres7.3.4.
> In this case all the databases will be on the one server.
> Initial research shows that the contrib/dblink module is needed....
> My question is:
>    Is this the only way to query across databases?

Yes, but, if your databases are all on one server under one postmaster
you should consider using one database with multiple schemas. See:
   http://www.postgresql.org/docs/current/static/sql-createschema.html

HTH,

Joe

pgsql-novice by date:

Previous
From: Jonathon Batson
Date:
Subject: Multi Database queries
Next
From: brew@theMode.com
Date:
Subject: Re: Multi Database queries