joining separate databases

From: bill(at)wadley(dot)org
To: pgsql-novice(at)postgresql(dot)org
Subject: joining separate databases
Date: 1969-12-31 23:59:59
Message-ID: Pine.LNX.4.21.6912311759590.3228-100000@wadley.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hello!

This may be missing the mark completely, but I figured I would ask:

I have a database containing our customers and our information product, and
I'm working on an internal project management app that will be stored in
another database (different machine, even).

Now, it occurs to me that I will want to join some tables from one database
with some tables in another one in-a-while, for instance if a customer is
responsible for a project, their contact information should be pulled from
the first database.

Or, to put it another way, I have two completely different problem domains
that intersect. I have a database for each domain. What if I want to join
them in some way? It just doesn't seem right to put every single table my
company creates into the same database, but I may be wrong.

Can anyone tell me where I'm going with this? Is there a school of thought,
or best practices, that I'm looking for? Anyone have a subject that can be
searched for?

Thanks!

--
Bill(at)Wadley(dot)org
Bill.Wadley.org/PGP_KEY.html
"The dinosaurs became extinct because they didn't have a space program."
-Larry Niven

Browse pgsql-novice by date

  From Date Subject
Next Message The Hermit Hacker 2000-03-30 20:16:41 [TEST] Archives should now work again ...
Previous Message claus 0100-09-12 13:59:39 Fwd: Re: inserting a file into a database.