Hi All..
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?

Jonathon




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Jonathon Batson wrote:
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/curre...ateschema.html

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Jonathon Batson wrote:

Another way is to make separate simultaneous connections in your
application (which you can do using the perl DBI and probably other
languages, too) and split up the query into separate queries for each
database, assembling them in the application.

Doing it this way the databases could be on separate machines.

That's not very convenient if you are doing this many times, but if that's
the case maybe you shouldn't be using separate databases anyway.

brew

================================================== ========================
Strange Brew (brew (AT) theMode (DOT) com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
================================================== ========================


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org